Experiences with PostgreSQL?

[PSiegmann]

Hello newsgroup,

We are hosting (and developing) an asp.net application on a dedicated
server, as database MS SQL Server Express 2005 is used.

We are currently happy with Express 2005, but, since the project will
grow, the 4 GB limit on the database will be a problem. This project
is currently too small to afford a pricey MS SQL 2005 standard edition
Server, so we are thinking about a migration to MySQL or PostgreSQL.

Now, MySQL is much more popular, but I am more symphatic towards
PostgreSQL, since stored procedures, Views, Triggers etc. are built in
since years into PostgreSQL, and are not an "afterthought" like in
MySQL.

But, I am still unsure what to take... I am the guy responsible for
the DB.. and to be honest, I don't have much experience with both,
MySQL and Postgre.

So, does anyone runs a asp.net site with postgreSQL here? How are your
experiences with it? Any problems? How is the performance on windows
server 2003?

 

[Alvin Bruney [MVP]]

I had to troubleshoot a postgresql issue with a bomain key. That turned out
to be several nights of grief. There's very little documentation and help
for these sorts of issues. MySql on the other hand is a bit more mature in
documentation and forum help.