PostgreSQL 8.2 Released
An anonymous reader writes to let us know that PostgreSQL 8.2 has been released (bits, release notes). 8.2 is positioned as a performance release. PostgreSQL it is still missing the SQL:2003 Window Functions that are critical in business reporting, so Oracle and DB2 will still win out for OLAP/data warehouse applications.
Sure would be nice to get bitmap indexes one of these days
God Fucking Damnit
Quit your fucking whining and read the goddamned instructions for a change.
While it was before I joined the company, they were reportedly using Linux on this very same system, with MySQL Enterprise. One of the DBAs had been using FreeBSD at home, and had found it to outperform Linux in many cases. From what I hear, he set up FreeBSD and MySQL on a test machine at work, and they found it blew Linux out of the water in terms of performance.
I'll ask Fred tomorrow about what sort of performance they originally got under Linux. Maybe I'll see if I can even find the documentation they would have had to have prepared to justify the switch.
It sounds like you just don't know how to deal with FreeBSD. That would explain the poor performance you experienced, and how it is completely contrary to what we've found.