These are a collection of things that I personally think every production PostgreSQL environment should have. This is generally stuff that my peers and I wouldn’t even discuss or debate; we just assume that it’s always a good idea. That said – there are a few items that still get discussed (for example, around scaling points or connection pool dynamic sizing) and the happiness hints will be biased toward my opinions on those items.
Note that these apply regardless of whether you manage PostgreSQL on your own hardware in your own datacenter, or whether you use hosted or managed PostgreSQL from a provider like Amazon RDS.
This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.I am currently looking for consulting and/or contracting work in the USA around the oracle database ecosystem.
contact:312-725-9249 orschneider @ ardentperf.com
Enter your email address to receive notifications of new posts by email.