Postgres Pro
Downloads
Home   >   mailing lists

Re: Inefficient min/max against partition (ver 9.1.1) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Inefficient min/max against partition (ver 9.1.1)
Date
Msg-id 10495.1330716660@sss.pgh.pa.us
Whole thread Raw
In response to Inefficient min/max against partition (ver 9.1.1)  ("McGehee, Robert" <Robert.McGehee@geodecapital.com>)
List pgsql-performance
Tree view 
"McGehee, Robert" <Robert.McGehee@geodecapital.com> writes:
> On PostgreSQL 9.1.1, I'm experiencing extremely slow/inefficient
> min/max queries against a partitioned table, despite the recent
> improvements made in version 9.1.

Thanks for the report.  I believe this will fix it:
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=ef03b34550e3577c4be3baa25b70787f5646c57b

            regards, tom lane

pgsql-performance by date:

Previous
From: Anssi Kääriäinen
Date:
Subject: Re: Large insert and delete batches
Next
From: Tomas Vondra
Date:
Subject: Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: [PERFORM] Re: 回复： [PERFORM] PG as in-memory db? How to warm up and re-populate buffers? How to read in all tuples into memory?