Anayrat links

UUIDv4 or UUIDv7 for a primary key? 5 million rows on PostgreSQL 18 | Explain, Measured

PostgreSQL · uuid

October 23, 2026 at 6:39:37 PM GMT+2 * · permalink

https://explainmeasured.com/posts/uuidv4-vs-uuidv7/

UUIDs stored as text: what it costs in PostgreSQL 18 | Explain, Measured

PostgreSQL · uuid

October 23, 2026 at 6:39:24 PM GMT+2 * · permalink

https://explainmeasured.com/posts/uuid-as-text/

All Your GUCs in a Row: bgwriter_lru_maxpages and bgwriter_lru_multiplier — The Build

PostgreSQL · pg_stat_bgwriter · GUC

October 20, 2026 at 5:41:55 PM GMT+2 * · permalink

https://thebuild.com/blog/all-your-gucs-in-a-row-bgwriterlrumaxpages-and-bgwriterlrumultiplier/

What gets TOASTed in Postgres — PlanetScale

PostgreSQL · toast · lz4

October 18, 2026 at 5:14:01 PM GMT+2 * · permalink

https://planetscale.com/blog/what-gets-toasted-in-postgres

Plan Advice in PostgreSQL 19 · Dimitri Fontaine

pg_plan_advice · pg19 · PostgreSQL

September 17, 2026 at 7:18:58 PM GMT+2 * · permalink

https://tapoueh.org/blog/2026/09/plan-advice-in-postgresql-19/

The dangers of Postgres subtransactions — PlanetScale

PostgreSQL · subtransaction · pg_stat_slru

September 9, 2026 at 5:54:07 PM GMT+2 * · permalink

https://planetscale.com/blog/the-dangers-of-postgres-subtransactions#detecting-and-preventing-overflow

An interactive TUI for reading PostgreSQL WAL (pg_walview) | MasahikoSawada

PostgreSQL · pg_walview · Extension

September 9, 2026 at 4:23:04 PM GMT+2 * · permalink

https://masahikosawada.github.io/2026/08/17/pg_walview/

Why Postgres Breaks Kubernetes container_memory_working_set_bytes Metric | Ardent Performance Computing

PostgreSQL · Kubernetes · memory

September 9, 2026 at 4:22:15 PM GMT+2 * · permalink

https://ardentperf.com/2026/08/18/why-postgres-breaks-kubernetes-container_memory_working_set_bytes-metric/

Give Us Access, Already — The Build

PostgreSQL · Consulting

September 7, 2026 at 8:44:52 PM GMT+2 * · permalink

https://thebuild.com/blog/give-us-access-already/

Getting Ready for PostgreSQL 19 · Dimitri Fontaine

PostgreSQL · pg19

September 3, 2026 at 3:27:51 PM GMT+2 * · permalink

https://tapoueh.org/blog/2026/09/getting-ready-for-postgresql-19/

Welcome to pg_walviz: PostgreSQL WAL segment visualizer

PostgreSQL · WAL · pg_walviz

August 15, 2026 at 9:38:14 AM GMT+2 * · permalink

https://bdrouvot.github.io/2026/08/13/welcome-to-pg-walviz-postgresql-wal-segment-visualizer/

Skyline Queries — The Gresql Post

SQL · not_read

August 11, 2026 at 9:31:42 PM GMT+2 * · permalink

https://thegresqlpost.org/articles/skyline-queries/

How PgBouncer Works

PgBouncer

June 30, 2026 at 9:29:05 AM GMT+2 * · permalink

https://www.augusteo.com/blog/how-pgbouncer-works/

The NULL in your NOT IN | boringSQL

PostgreSQL · not_read

June 23, 2026 at 7:07:14 PM GMT+2 * · permalink

https://boringsql.com/posts/not-in-null/

Optimising Polymorphic Associations in PostgreSQL

PostgreSQL · not_read

June 23, 2026 at 7:05:09 PM GMT+2 * · permalink

https://danolivo.substack.com/p/optimising-polymorphic-associations

RUM—Storing More in the Index - DEV Community

PostgreSQL · RUM

June 23, 2026 at 7:02:27 PM GMT+2 * · permalink

https://dev.to/franckpachot/rum-storing-more-in-the-index-4hoe

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements | AWS Database Blog

PostgreSQL · pg18 · not_read

June 23, 2026 at 3:24:44 PM GMT+2 * · permalink

https://aws.amazon.com/blogs/database/postgresql-18-on-amazon-aurora-and-amazon-rds-performance-enhancements/

When is a function leakproof?

PostgreSQL · leakproof · not_read

June 23, 2026 at 3:24:21 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/when-is-a-function-leakproof/

When failover isn’t safe: Building high-availability PostgreSQL on Kubernetes | Datadog

PostgreSQL · HA · Patroni

June 19, 2026 at 9:41:00 AM GMT+2 * · permalink

https://www.datadoghq.com/blog/engineering/postgresql-ha-kubernetes/

Surviving a Patroni failover with logical replication

PostgreSQL · not_read · logique · Patroni

June 14, 2026 at 9:42:11 AM GMT+2 * · permalink

https://www.dbi-services.com/blog/surviving-a-patroni-failover-with-logical-replication/