I have been using MySQL for a couple of years now, but am interested in using PostgreSQL. Currently, MySQL does not support stored procedures or transactions -- a couple of features that could be useful for some of my current projects.

Does anyone have experience with both? As I have several questions about performance and memory usage.

For example, MySQL is reportedly much faster than PostgreSQL, but does this hold when using store procedures for complex queries in PostgreSQL?

How does the PostgreSQL memory footprint compare to MySQL?

Any pointers would be appreciated....

When it is something easy to be done or that doesn't require complex I always go with mysql, you can also compile it with support for berkeley tables and you can also have support for transactions.

I work with postgresql when I need to fetch some information from my raq, I hold a list of sites in my raq on my main page and I read them right from the cobalt table, with this I have noticed that postgresql demands more memory than mysql.