News for hackers. Stuff that matters.
Re:Postgresql 9.2 will have boat-loads of performance enhanc... by masklinn on Wednesday November 30, 2011 @12:55PM (#3295962)
> what about performance / reliability?

Postgres has very good reliability (for the longest time, reliability and completeness were the only two driving goals of the project). It also has acceptable-to-good performances (on unices anyway) but the default configuration is completely untuned.

This default is meant to run on very weak machines, so the db "works" everywhere OOTB, many people don't configure their postgres (and it's not been trivial historically, it's gotten a lot better) and end up with miserable performances.

This issue is most visible with "the other open-source database" (MySQL) as it has 1. a much more aggressive default configuration and 2. MyISAM default (I think it might have been switched now, but that's pretty recent), which has very fast reads (and nothing else)

An other issue with postgres is probably the lack of postgres DBAs (let alone good ones) compared to Oracle and MSSQL, though any good and open-minded DBA should be able to get up-to-speed quick on it. The last issue would be tooling, I believe MS provides lots of administration and GUI tools for MSSQL, there's a dearth of those for postgres.

Re:Postgresql 9.2 will have boat-loads of performance enhanc... by grey on Wednesday November 30, 2011 @08:46PM (#3297878)
There's a fair number of really good Postgres tools out there, or tools that support Postgres among other platforms, They're just pricey. The free tools are passable but not that good.
Re:Postgresql 9.2 will have boat-loads of performance enhanc... by jeltz on Thursday December 01, 2011 @05:20AM (#3299091)
For me personally PostgreSQL makes up for the lack of good free graphical tools by providing an excellent command line client, psql, and good utility views and functions. I much prefer it to the CLIs of MySQL, Oracle and SQLite.