On 06/22/2011 05:55 AM, Marti Raudsepp wrote:
Now I created a wiki snippet page for this handy feature here: https://wiki.postgresql.org/wiki/Efficient_min/max_over_partitioned_table
I just tweaked this a bit to document the version compatibility issues around it and make it easier to follow. I think that's now the page we should point people toward when this pops up again. Between that and my blog post I reference in it, they can find all the details and a workaround in one place.
-- Greg Smith 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us "PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance