Content by esantana (2)

esantana explains how PostgreSQL table bloat persists even after autovacuum removes dead tuples. A test on Azure Database for PostgreSQL Flexible Server demonstrates the storage and query effects of VACUUM FULL, alongside practical guidance on diagnostics, prevention, online alternatives, and the locking and resource costs of maintenance.
Community
esantana explains how to address connection pressure and read-heavy workloads in Azure Database for PostgreSQL using PgBouncer, read replicas, virtual endpoints, and Pgpool-II. The walkthrough covers installation, authentication, routing validation, and maintenance, while highlighting replica lag, middleware availability requirements, and when application-level caching with Azure Managed Redis fits.
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.