Posts by Ahmed Darwich
Ahmed Darwich [@AhmedDarwich] |
ARM and x86 can give you different performance at the same vCPU count. Here's what differs, what to measure, and how to choose. →
Andres Taylor, Harshit Gangal, Ahmed Darwich [@AhmedDarwich] |
A Neki router gives applications a Postgres connection to one database while planning and coordinating queries across the shards behind it. →
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 4 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. →