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.
Things that I miss in postgresql: - materialized views !! - a better graphical management tool.