EDB PostgreSQL Associate case studies
EDB PostgreSQL Associate · Put your knowledge to work in context.
The EDB PostgreSQL Associate is an early-career certification intended to show that a candidate has a solid working foundation in PostgreSQL - the open-source database that EDB has contributed to since 2006 and builds its commercial products on. It is aimed at database administrators, developers, data engineers and platform engineers who are starting to run Postgres in real environments, and at professionals arriving from another relational platform who need to prove they can transfer their skills. The EDB PostgreSQL Associate case studies are 5 cases and about 4,116 words.
1Nightly OOM kills on a 64 GB primary
A 64 GB / 16-core primary runs PostgreSQL with max connections = 500, shared buffers = 16 GB and work mem = 64 MB; hash mem multiplier is left at its default of 2.0. Application servers connect directly with no pooler.
568 words, about 3 min2Partitioned events table that never prunes
An events table holds 480 million rows (about 1.2 TB) and is range-partitioned by created at into 24 monthly partitions, plus a DEFAULT partition for anything newer. Retention is implemented by dropping the oldest partition each month.
844 words, about 4 min3PITR fails after a silent gap in the WAL archive
A 2 TB OLTP database takes a nightly pg basebackup at 02:00 to an NFS mount, with archive mode = on and archive command = '/usr/local/bin/archive wal.sh %p %f'. The script copies the segment; its final line is exit 0 , added by a former DBA so that the logs would stop filling with errors.
890 words, about 4 min4Row-level security that silently does nothing
A B2B SaaS runs 60 tenants in one database. All tables carry a tenant id column.
894 words, about 4 min5Synchronous replication that takes the site down
A primary runs with synchronous standby names = 'FIRST 2 (sb1, sb2)' and synchronous commit = on . sb1 is in the same rack; sb2 is in a second datacenter with 30 ms round-trip latency.
920 words, about 5 min