TIL · postgres

REPLICA IDENTITY on a partitioned table doesn't cascade

postgres · Jul 17, 2026

ALTER on the parent looks like it configured CDC, but the leaf partition is what counts.
docker exec -t injects CR into your pg_dump

postgres · Jul 11, 2026

-t allocates a TTY and turns \n into \r\n across the whole dump.
Postgres LATERAL join for top-N per group

postgres · Jun 28, 2026

Get the N most recent rows of each group without a window function.