Long-time readers/listeners know I’m a Postgres fan, but I sometimes wonder if I heap too much praise on my favorite database. Enter Rick Branson:
While much of this praise is certainly well-deserved, the lack of meaningful dissent left me a bit bothered. No software is perfect, so exactly what are PostgreSQL’s imperfections?
I’ve been hands-on with PostgreSQL in production since 2003 with deployments ranging from small (gigabytes) to modest to very large (~petabyte). My perspective is largely from building and running systems that are at least intended to be continuously available. Needless to say, I have gained first-hand experience with PostgreSQL’s particular idiosyncrasies through some painful production issues over the years.
Rick has worked with much larger PG installs than I have, so his insights on this subject are well-grounded.