Search: [PostgreSQL] - Anayrat links

WHAT CAN POSTGRES LEARN FROM DUCKDB?

PostgreSQL · not_read · duckDB

May 27, 2025 at 15:06:47 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 15:06:18 GMT+2 * · permalink

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

The Present and Future of VACUUM in PostgreSQL

PostgreSQL · not_read · Vacuum

May 27, 2025 at 15:05:30 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 14:59:16 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 14:56:31 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 09:40:35 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 09:38:33 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 22:37:20 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 · not_read · pg18 · asyncio

May 7, 2025 at 22:53:00 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 15:17:29 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 GMT+2 * · permalink

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

PostgreSQL planner development and debugging - DEV Community

PostgreSQL · planner · hack · Internal · not_read

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

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

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

pg_stat_statements · PostgreSQL

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

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

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

PostgreSQL · optimizer · sort · group_by · planner

November 26, 2024 at 17:11:38 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 GMT+1 * · permalink

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

Speeding Up Foreign Key Constraints During Migrations

PostgreSQL · fk

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

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

⚡ pgdoc.link ⚡

PostgreSQL · doc

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

https://pgdoc.link/

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

PostgreSQL · podcast

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

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

Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints – select * from depesz;

PostgreSQL · PERIOD · pg18

October 7, 2024 at 17:32:08 GMT+2 * · permalink

https://www.depesz.com/2024/10/03/waiting-for-postgresql-18-add-temporal-foreign-key-contraints/

Contraintes temporelles dans PostgreSQL 18

PostgreSQL · pg18

October 2, 2024 at 20:13:26 GMT+2 * · permalink

https://blog.dalibo.com/2024/10/01/postgresql-18-contraintes-temporelles.html