Content by richyen (1)
richyen examines why an indexed query slowed after migration to Azure Database for PostgreSQL. Counting distinct heap pages revealed that parallel loading had scattered related rows. The article explains how to diagnose physical layout differences, reorganize data, and compare performance while accounting for cache effects and maintenance constraints.
End of content