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.
Comments are closed.