Anayrat links

Tracking plan shapes over time with Plan IDs + a new pg_stat_plans

pg_stat_plans · PostgreSQL · Extension

May 27, 2025 at 2:56:31 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/444/slides/63/2025-05-14%20PGConf.dev%20-%20Tracking%20plan%20shapes%20over%20time%20with%20Plan%20IDs,%20and%20a%20new%20pg_stat_plans.pdf

Split-brain in case of network partition · cloudnative-pg/cloudnative-pg · Discussion #7462 · GitHub

PostgreSQL · HA · Patroni

May 27, 2025 at 9:40:35 AM GMT+2 * · permalink

https://github.com/cloudnative-pg/cloudnative-pg/discussions/7462

Root Cause Analysis: PostgreSQL MultiXact member exhaustion incidents (May 2025) | Metronome blog

PostgreSQL · multixact · Internal

May 27, 2025 at 9:38:33 AM GMT+2 * · permalink

https://metronome.com/blog/root-cause-analysis-postgresql-multixact-member-exhaustion-incidents-may-2025

Debugging memory leaks in Postgres, heaptrack edition

PostgreSQL · not_read · Internal

May 25, 2025 at 10:37:20 PM GMT+2 * · permalink

https://www.enterprisedb.com/blog/debugging-memory-leaks-postgres-heaptrack-edition

Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O

PostgreSQL · pg18 · asyncio

May 7, 2025 at 10:53:00 PM GMT+2 * · permalink

https://pganalyze.com/blog/postgres-18-async-io

Waiting for PostgreSQL 18 – Non text modes for pg_dumpall, correspondingly change pg_restore – select * from depesz;

PostgreSQL · pg18 · pg_dump

April 15, 2025 at 3:17:29 PM GMT+2 * · permalink

https://www.depesz.com/2025/04/15/waiting-for-postgresql-18-non-text-modes-for-pg_dumpall-correspondingly-change-pg_restore/

The Wide World of GiST Indexes - Simple Talk

PostgreSQL · not_read · GiST

March 30, 2025 at 11:11:15 AM GMT+2 * · permalink

https://www.red-gate.com/simple-talk/databases/postgresql/the-wide-world-of-gist-indexes/

How Core Git Developers Configure Git

git

February 27, 2025 at 3:29:13 PM GMT+1 * · permalink

https://blog.gitbutler.com/how-git-core-devs-configure-git/

PostgreSQL planner development and debugging - DEV Community

PostgreSQL · planner · hack · Internal · not_read

February 12, 2025 at 11:45:35 AM GMT+1 * · permalink

https://dev.to/ashenblade/postgresql-planner-development-and-debugging-47mc

Talking Postgres with Claire Giordano | Why mentor Postgres developers with Robert Haas

not_read

February 11, 2025 at 6:36:57 PM GMT+1 * · permalink

https://talkingpostgres.com/episodes/why-mentor-postgres-developers-with-robert-haas

Some of My Favorite Things – Postgres Queries | 🛩️ Shane Borden's Technology Blog

pg_stat_statements · PostgreSQL

December 18, 2024 at 4:17:03 PM GMT+1 * · permalink

https://stborden.wordpress.com/2024/12/17/some-of-my-favorite-things-postgres-queries/

Keyset Cursors, Not Offsets, for Postgres Pagination

SQL · offset

December 16, 2024 at 10:59:16 AM GMT+1 * · permalink

https://blog.sequinstream.com/keyset-cursors-not-offsets-for-postgres-pagination/

https://danolivo.substack.com/p/could-group-by-clause-reordering

PostgreSQL · optimizer · sort · group_by · planner

November 26, 2024 at 5:11:38 PM GMT+1 * · permalink

https://danolivo.substack.com/p/could-group-by-clause-reordering

MultiXacts in PostgreSQL: usage, side effects, and monitoring | AWS Database Blog

PostgreSQL · multixact

November 19, 2024 at 12:16:47 PM GMT+1 * · permalink

https://aws.amazon.com/fr/blogs/database/multixacts-in-postgresql-usage-side-effects-and-monitoring/

Home page | NKON

battery · lithium

November 3, 2024 at 8:09:06 PM GMT+1 * · permalink

https://eu.nkon.nl/

Speeding Up Foreign Key Constraints During Migrations

PostgreSQL · fk

November 3, 2024 at 6:40:33 PM GMT+1 * · permalink

https://dev.to/yugabyte/speeding-up-foreign-key-constraints-during-migrations-3a9o

⚡ pgdoc.link ⚡

PostgreSQL · doc

October 30, 2024 at 9:39:46 AM GMT+1 * · permalink

https://pgdoc.link/

https://www.kernel.org/doc/Documentation/device-mapper/cache.txt

LVM · Cache · linux · Kernel

October 25, 2024 at 4:07:34 PM GMT+2 * · permalink

https://www.kernel.org/doc/Documentation/device-mapper/cache.txt

LVM Cache Modes and Behavior

LVM · Cache · linux · Kernel

October 25, 2024 at 4:07:13 PM GMT+2 * · permalink

https://lucaswerkmeister.de/posts/2022/07/03/lvmcache/

Talking Postgres with Claire Giordano | How I got started as a developer (& in Postgres) with Tom Lane

PostgreSQL · podcast

October 17, 2024 at 9:37:16 PM GMT+2 * · permalink

https://share.transistor.fm/s/8e643aed