Anayrat links

Waiting for PostgreSQL 19 – Display Memoize planner estimates in EXPLAIN – select * from depesz;

PostgreSQL · memoize · pg19

August 12, 2025 at 10:50:42 AM GMT+2 * · permalink

https://www.depesz.com/2025/08/04/waiting-for-postgresql-19-display-memoize-planner-estimates-in-explain/

Postgres Replication Slots: Confirmed Flush LSN vs. Restart LSN - Gunnar Morling

PostgreSQL · logique · Replication · lsn

August 12, 2025 at 10:47:28 AM GMT+2 * · permalink

https://www.morling.dev/blog/postgres-replication-slots-confirmed-flush-lsn-vs-restart-lsn/

When to Hire a Computer Performance Engineering Team (2025) part 1 of 2

Brendan · Gregg

August 5, 2025 at 10:12:59 PM GMT+2 * · permalink

https://www.brendangregg.com/blog/2025-08-04/when-to-hire-a-computer-performance-engineering-team-2025-part1.html

pg_dphyp: teach PostgreSQL to JOIN tables in a different way - DEV Community

PostgreSQL · planner

August 1, 2025 at 11:34:41 PM GMT+2 * · permalink

https://dev.to/ashenblade/pgdphyp-teach-postgresql-to-join-tables-in-a-different-way-33o8

Analyzing PostgreSQL Performance Using Flame Graphs | Jan’s website and blog

PostgreSQL · flamegraph

July 6, 2025 at 12:33:45 PM GMT+2 * · permalink

https://jnidzwetzki.github.io/2025/07/05/postgresql-flamegraph.html

Avoid UUID Version 4 Primary Keys | Software Engineer, Author, High Performance PostgreSQL for Rails

PostgreSQL · uuid

July 2, 2025 at 8:40:17 PM GMT+2 * · permalink

https://andyatkinson.com/constraint-driven-optimized-responsive-efficient-core-db-design

PostgreSQL UUID Performance: Benchmarking Random (v4) and Time-based (v7) UUIDs - DEV Community

PostgreSQL · uuid

June 22, 2025 at 5:23:35 PM GMT+2 * · permalink

https://dev.to/umangsinha12/postgresql-uuid-performance-benchmarking-random-v4-and-time-based-v7-uuids-n9b

Le partitionnement par UUID v7

PostgreSQL · uuid

June 22, 2025 at 5:22:54 PM GMT+2 * · permalink

https://fljd.in/2025/06/17/le-partitionnement-par-uuid-v7/

The fastest Postgres inserts - Hatchet Documentation

PostgreSQL · copy

May 28, 2025 at 9:34:17 PM GMT+2 * · permalink

https://docs.hatchet.run/blog/fastest-postgres-inserts

Big Problems From Big IN lists with Ruby on Rails and PostgreSQL | Software Engineer, Author, High Performance PostgreSQL for Rails

PostgreSQL · pg18 · IN

May 28, 2025 at 9:29:21 PM GMT+2 * · permalink

https://andyatkinson.com/big-problems-big-in-clauses-postgresql-ruby-on-rails

Improving scalability; Reducing overhead in shared memory

PostgreSQL · Internal · memory

May 27, 2025 at 3:08:09 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/359/slides/65/2025-05%20-%20PGConf.DEV%20-%20Shared%20memory.pdf

WHAT CAN POSTGRES LEARN FROM DUCKDB?

PostgreSQL · duckDB

May 27, 2025 at 3:06:47 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/318/slides/67/PGConf.dev%202025%20-%20What%20Postges%20Can%20Learn%20from%20DuckDB_.pdf

Writing fast C code for a modern CPU

PostgreSQL · C

May 27, 2025 at 3:06:18 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/419/slides/88/Writing_fast_C_code_for_a_modern_CPU.pdf

What is new in C and POSIX?

PostgreSQL · C

May 27, 2025 at 3:05:48 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/271/slides/69/What%20is%20new%20in%20C%20and%20POSIX_.pdf

The Present and Future of VACUUM in PostgreSQL

PostgreSQL · Vacuum

May 27, 2025 at 3:05:30 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/281/slides/85/The_Present_and_Future_of_Vacuum_in_PostgreSQL.pdf

Multidimensional search strategies for composite B-Tree indexes

PostgreSQL · skip · loose_index_scan

May 27, 2025 at 2:59:16 PM GMT+2 * · permalink

https://www.pgevents.ca/events/pgconfdev2025/sessions/session/229/slides/71/multidimensional-search-talk-pgconfdev.pdf

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