Anayrat links

PostgreSQL 18 supports UUIDv7

PostgreSQL · uuid · pg18

September 5, 2025 at 8:08:14 PM GMT+2 * · permalink

https://masahikosawada.github.io//en/2025/09/04/UUIDv7-in-PostgreSQL/

History of improvements in VACUUM in PostgreSQL

PostgreSQL · Vacuum

August 15, 2025 at 10:39:24 PM GMT+2 * · permalink

https://www.enterprisedb.com/postgres-tutorials/history-improvements-vacuum-postgresql

Should I rebuild my PostgreSQL index? | CYBERTEC PostgreSQL | Services & Support

PostgreSQL · pg18

August 12, 2025 at 11:03:34 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/should-i-rebuild-my-postgresql-index/

btree_gist improvements in PostgreSQL 18 | CYBERTEC PostgreSQL | Services & Support

PostgreSQL · pg18 · btree_gist

August 12, 2025 at 11:02:42 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/btree_gist-improvements-in-postgresql-18/

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 · not_read

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 · not_read · 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 · not_read

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?

not_read

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

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

PostgreSQL · not_read · 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