Posts by Ahmed Darwich
Harshit Gangal, Ahmed Darwich [@AhmedDarwich] |
A data topology describes the sharding scheme a Neki router uses to map logical PostgreSQL tables to physical shards and route queries. →
Ahmed Darwich [@AhmedDarwich] |
`VACUUM` reclaims dead-tuple space but doesn't shrink a table. PostgreSQL 19 Beta 2 adds an in-core online rewrite with REPACK (CONCURRENTLY), and much more. →
Jan Nidzwetzki, Etienne Berube, Ahmed Darwich [@AhmedDarwich] |
What happens to old row versions after nobody needs them? They become dead tuples, and over time they bloat your tables. Go deeper into PostgreSQL MVCC with runnable psql examples. →