I use PostgreSQL every single day. I develop against multiple versions of the database (4 versions running in parallel as I write), I have apps that use it and, my daily DBA-ing. The biggest question I get from newbies and veterans a like is: “What are your PostgreSQL defaults?”
If you follow postgres, you already know that the default configuration (postgresql.conf) is very conservative from a resource (CPU, IOPS, Disk Space) perspective. Over the last 10 years, we [the community] have developed some straightforward and easy to understand formulas that will help you tune… shared_buffers for example. The item that always gets left out though is logging. As a developer, I’m always looking for ways to see “How the database is answering the questions I ask”. When I get a new postgres instance set up, I have a personal (somewhere in the cobwebs) checklist that I run. Some are based on the purpose of the deployment (shared_buffers, work_mem, etc…), some are things that I always set. Aside from memory, the biggest set of “standard” items I set are all related to logging. I’m big on monitoring (my pg_stat_activity patch was accepted back for 9.2) and having the right detail presented to me is important.