Hello,
> I'm more concerned though about the complete experience, i.e.
> postgresql performance on Linux vs Bsd vs Windows...
> Maintainability.. Stability... os tweeks that were really needed to
> make pg work well, etc.
>
> I would really like to hear from those who have used postgresql on
> multiple operating systems..
I've used PostgreSQL on lots of Unixes. Most of the advantages and
disadvantages of those are not database-specific. Here are some
pro's of each of them:
BSDs: centralized, well-organized code management, code well thought-out
and readable, especially NetBSD. Good performance and reliability.
Linux: supports hardware faster, so if you want to play video games
or have rare network cards, use this.
Mac OS: pleasing user interface, easier administration for
non-technicians, good performance
Solaris: superior OS architecture and features, esp. in Solaris 10
(unbeatable diagnostics with dtrace/mdb), high degree of automization
(hands-off installation and configuration of everything)
Notice: BSD, Linux, and Solaris cost nothing. Mac OS is payware.
Sources are available for BSDs, Linux, Mac OS (the "Unix" subset),
and (within the next 5 weeks) Solaris.
So, if you're a professional, go with NetBSD or Solaris.
If you want a system that your grandparents (may they still be living)
feel comfortable with, take Mac OS X.
Greetings,
Rainer