What I really like about PostgreSQL compared to e.g. MySQL is the support for partial indexes (http://www.postgresql.org/docs/8.0/static/indexes-partial.html ht

What I really like about PostgreSQL compared to e.g. MySQL is the support for partial indexes (http://www.postgresql.org/docs/8.0/static/indexes-partial.html http://www.postgresql.org/docs/8.0/static/indexes-partial.ht...). Especially when keeping normalized data, it allows the easy creation of an index without having the need to index ALL records and blow up the b+tree