Browse incidents, troubleshooting guides, AI diagnostics, verified fixes and community discussions related to postgre.
## Environment PostgreSQL 14.5 primary on Debian 11 (dedicated server), partitioned table (range partitions by date, ~120 partitions), application servers connect via PgBouncer v1.17.0 in transaction pooling mode; app uses psycopg2 with prepared sta...
## Environment PostgreSQL upgraded in-place from 13.5 to 14.2 on Ubuntu 20.04 LTS. A third-party C extension (installed from distro package and also a site-built variant) is listed in shared_preload_libraries and the cluster runs on a 16-core VM wit...
## Environment Primary: PostgreSQL 13 on bare-metal (12 cores, 64GB), Logical replication slot streaming to replica on PostgreSQL 13; large table (~2 TB, 500M rows) in production; ALTER TABLE ADD COLUMN ... DEFAULT X NOT NULL executed during low-tra...
## Environment PostgreSQL 13.7 primary on Debian 11 (8-core VM), three synchronous replicas on separate hosts. Streaming replication over TLS (server certs) through a TCP load balancer that enforces SSL session renegotiation every 60s. wal_level = r...
## Environment PostgreSQL 13 cluster: primary on cloud VM (8 vCPU, 32GB RAM), standby streaming replication over 1 Gbps link; autovacuum aggressive tuning with autovacuum_max_workers=20 and autovacuum_naptime=10s, several large partitioned tables wi...
## Environment Primary: PostgreSQL 13.6 on Ubuntu 20.04, physical host with 1 Gbps NIC. archive_mode = on, archive_command = 'rsync --relative %p backup@backup-host:/data/pg_wal/%f'. pg_basebackup run from backup host to create base backup while WAL...
## Environment Primary PostgreSQL 13.9 on Ubuntu 20.04 with streaming replication to a hot standby using physical replication slots. pg_repack 1.4.9 run on large table during low-traffic window. WAL archiving to file system enabled. Replica on same ...
## Environment PostgreSQL 13 on Debian 11, 48 GB RAM, NVMe RAID on controller with battery-backed write cache; workload: OLTP with peak 2000 TPS; changed shared_buffers from 4GB to 16GB and restarted PostgreSQL at 02:00 during low traffic ## Sympto...
## Environment Ubuntu 20.04 LTS, PostgreSQL 14.5 installed from PGDG repository on a bare-metal server (8 cores, 32 GB RAM, 2 x 2 TB NVMe, ext4). Single database with a monthly-partitioned table ~120M rows; autovacuum left at package defaults. ## S...
## Environment PostgreSQL 13.5 on Ubuntu 20.04, application server using libpq with prepared statements (persistent prepared transactions), workload: web app that uses a read step (SELECT ... FOR SHARE) under SERIALIZABLE isolation and later issues ...