PostgreSQL 8.4 Out
TheFuzzy writes "PostgreSQL version 8.4 is now out and available for download. The main cool features in this version are: recursive queries (for doing trees etc.), windowing functions (for doing reports) column-level permissions, parallel database restore, a beta in-place upgrade tool, and a host of administrative improvements. And, of course, better performance, mainly on reporting queries. Some of the over 200 new or enhanced features are listed here."
In theory, I too was much in favor of PostgreSQL over MySQL, for many years, until VERY recently, when I actually got around to using it for serious projects. Then I discovered that pgadmin on windows can't even backup a PostgreSQL server unless the versions match EXACTLY (minors as well as majors) across builds and platforms. That's pretty insane. I'm now worried about what other seemingly obvious issues might not have been addressed in pg.
wow. That didn't sound rabidly defensive at all. Not in the least.
This is my sig. There are many like it but this one is mine.