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.
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.
End of content