PostgreSQL

[edit] Useful Links

You NEED to read the documentation on configuring your PostgreSQL installation. Otherwise, it WILL be slow. It doesn't take a lot of work to understand what the configurations control and how to set them to the right numbers.
You NEED to run VACUUM ANALYZE from time to time on your tables. You should setup a cron job to do so, or use one of the available tools to automatically vacuum tables when they need it. If you do only a vacuum, your queries will always be poorly planned. If you don't vacuum at all, then your entire database will crawl to a halt.

Other than that, you should be set to go.

PostgreSQL has a type system that works. It is extensible, it makes sense, and it is a pleasure to use.
PostgreSQL allows you to program in several different languages in the database. You can also write your own extensions writing C.
PostgreSQL's codebase is wonderful to work with.
PostgreSQL doesn't have a rollback segment like Oracle.
PostgreSQL is really, really scalable. That is, as the number of concurrent connections go up, it does not slow down exponentially like MySQL.

They think PostgreSQL hasn't progressed any since 10 years ago.
They think it is slow because they haven't configured it properly.
They think it is hard because it doesn't try to hide the reality of ACID compliance from the user.
They think it is hard because it is not MySQL, Microsoft SQL Server, or Oracle.
They think it is dumb because you have to run vacuum from time to time.
They think they know better than the planner because it prefers to run table scans rather than index lookups when you are faster doing a table scan anyway.
They think the planner is dumb because they haven't analyzed the data to give the planner hints on how to plan queries yet.
They think it is dumb and stupid because all their money and business is riding on the success of their favorite database which is costing them millions and doesn't perform nearly as well as PostgreSQL.
They think it isn't enterprise ready because it doesn't require thousands of tools and books to keep the system running. (Apparently, enterprise-ready means you need a team of DBAs just to keep the thing alert, according to some people.)
They think it is slow because PostgreSQL runs on top of the OS file partitions.
They think that PostgreSQL users are snobby because they talk about data normalization, ACID compliance, and nested SELECT statements.

hstore - A hash/dict/mapping datatype in PostgreSQL, with appropriate operators. http://www.sai.msu.su/~megera/postgres/gist/hstore/README.hstore