Lord_Majestic - 12:26 pm on Oct 10, 2005 (gmt 0)

how is Postgres looking?

The biggest issue with PostgreSQL I had was necessity to "vacuum" it regularly as otherwise performance would fall to unacceptable levels (and I mean unacceptable), this vacuuming is a slow process that can pretty much lock out database so its not easy to have 24/7.

Now take my words with a pinch of salt -- I am not expert in PostgreSQL and I am sure there are ways to tune it to avoid the issue I described before, in my case it was not critical, more of an annoyance really. Since the database is superb overall and free, I can't really say that problems with PostgreSQL were big enough to switch to Oracle or even SQL Server (which I actually prefer due to long experience with T-SQL syntax, but I am not paying ridiculous amount of money they want).