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.
Community

End of content

Rejoining the server...

Rejoin failed... trying again in seconds.

Failed to rejoin.
Please retry or reload the page.

The session has been paused by the server.

Failed to resume the session.
Please reload the page.