Anayrat links

The collation versioning problem with ICU 73

PostgreSQL · ICU

October 20, 2023 at 6:51:00 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2023/10/20/icu-73-versioning.html

JSON Path Operator Confusion

PostgreSQL · jsonpath · JSON

October 15, 2023 at 9:57:31 PM GMT+2 * · permalink

https://justatheory.com/2023/10/sql-jsonpath-operators/

Linux Kernel Teaching — The Linux Kernel documentation

linux · Kernel

October 13, 2023 at 1:50:16 PM GMT+2 * · permalink

https://linux-kernel-labs.github.io/refs/heads/master/index.html

Using traditional calendars with ICU

PostgreSQL · ICU

October 11, 2023 at 11:37:13 PM GMT+2 * · permalink

https://postgresql.verite.pro/blog/2023/09/27/icu-traditional-calendars.html

pg_stat_io and PostgreSQL 16 performance

PostgreSQL · pg16 · pg_stat_io

October 6, 2023 at 8:42:58 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/pg_stat_io-postgresql-16-performance/

MERGE() - A Quick Introduction

PostgreSQL · MERGE · pg15

October 6, 2023 at 8:36:29 PM GMT+2 * · permalink

https://postgresql.us/events/pgconfnyc2023/sessions/session/1243/slides/94/PGNYC%20Merge.pdf

Ceph performance — YourcmcWiki

SSD

September 28, 2023 at 10:30:27 PM GMT+2 * · permalink

https://yourcmc.ru/wiki/Ceph_performance

Demystifying Database Transcations | Dinesh Gowda

PostgreSQL · MVCC · Isolation

September 28, 2023 at 9:04:31 PM GMT+2 * · permalink

https://dineshgowda.com/posts/demystifying-database-transcations/

PostgreSQL EXPLAIN Glossary - pgMustard

PostgreSQL · explain

September 27, 2023 at 5:09:56 PM GMT+2 * · permalink

https://www.pgmustard.com/docs/explain

Understanding EXPLAIN - part 1 - Costs and actual time | Louise Grandjonc, Python/SQL developer but also a human

PostgreSQL · explain

September 27, 2023 at 5:03:54 PM GMT+2 * · permalink

http://www.louisemeta.com/blog/explain/

PostgreSQL: Feature Matrix

PostgreSQL · versions

September 26, 2023 at 4:09:37 PM GMT+2 * · permalink

https://www.postgresql.org/about/featurematrix/

PostgreSQL major versions - pgPedia - a PostgreSQL Encyclopedia

PostgreSQL · versions

September 26, 2023 at 3:36:45 PM GMT+2 * · permalink

https://pgpedia.info/postgresql-versions/index.html

Why upgrade PostgreSQL?

PostgreSQL · versions · Upgrade · config · Settings · GUC

September 26, 2023 at 3:36:23 PM GMT+2 * · permalink

https://why-upgrade.depesz.com

postgresql.conf compare

PostgreSQL · versions · config · Settings · GUC

September 26, 2023 at 3:36:00 PM GMT+2 * · permalink

https://pgconfig.rustprooflabs.com/

GitHub - neondatabase/pg_embedding: Hierarchical Navigable Small World (HNSW) algorithm for vector similarity search in PostgreSQL

PostgreSQL · vector

September 26, 2023 at 1:33:18 PM GMT+2 * · permalink

https://github.com/neondatabase/pg_embedding

GitHub - lanterndata/lantern: PostgreSQL vector database extension for building AI applications

PostgreSQL · vector

September 26, 2023 at 1:32:36 PM GMT+2 * · permalink

https://github.com/lanterndata/lantern

Postgres Performance Tuning, Part III: Optimizing Indexes

PostgreSQL · index

September 22, 2023 at 12:15:56 AM GMT+2 * · permalink

https://www.timescale.com/blog/postgresql-performance-tuning-part-iii-optimizing-postgresql-indexes/

Timed wait events in PostgreSQL

PostgreSQL · BPF · eBPF · hack · Internal

September 21, 2023 at 5:56:54 PM GMT+2 * · permalink

https://databaseperformance.hashnode.dev/timed-wait-events-in-postgresql

JSON Updates in Postgres 16

PostgreSQL · JSON · pg16

September 20, 2023 at 10:02:05 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/json-updates-postgres-16

When to Consider Postgres Partitioning

PostgreSQL · partionning

September 14, 2023 at 11:13:18 AM GMT+2 * · permalink

https://www.timescale.com/blog/when-to-consider-postgres-partitioning/