[rdunklau]

On the top of my head, another list of features worth looking at: - ARRAY support: makes your life easier, especially the array_agg aggregation function - HSTORE extension: use postgresql like a key/value store - SQL/MED implementation, foreign data wrappers: allows you to define external data sources as an extension.

Things that I miss in postgresql: - materialized views !! - a better graphical management tool.

[omarqureshi]

You can most certainly use matviews

http://tech.jonathangardner.net/wiki/PostgreSQL/Materialized...

it's not part of pg - but, it is something that you can write yourself due to the awesomeness of plpgsql.

[einhverfr]

I mentioned ARRAY support in the context of complex types, but it could definitely get its own entry. I haven't played much with hstore, but there are a few places LedgerSMB might be able to use it in the future.

SQL/MED is also worthy of mention, but again kind of fell outside my focus.