Re: Inefficient min/max against partition (ver 9.1.1)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "McGehee, Robert" <Robert(dot)McGehee(at)geodecapital(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inefficient min/max against partition (ver 9.1.1)
Date: 2012-03-02 19:31:00
Message-ID: 10495.1330716660@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"McGehee, Robert" <Robert(dot)McGehee(at)geodecapital(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2012-03-03 00:30:18 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?
Previous Message Anssi Kääriäinen 2012-03-02 12:51:53 Re: Large insert and delete batches