News for hackers. Stuff that matters.
Re:Underrated Features of PostgreSQL by rdunklau on Wednesday November 02, 2011 @01:11PM (#3187819)
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.

Re:Underrated Features of PostgreSQL by omarqureshi on Wednesday November 02, 2011 @01:28PM (#3187907)
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.

Re:Underrated Features of PostgreSQL by einhverfr on Wednesday November 02, 2011 @09:52PM (#3189832)
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.