Re: select max(column) from parent table very slow - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: select max(column) from parent table very slow
Date
Msg-id 44EF15F9.7040807@commandprompt.com
Whole thread Raw
In response to Re: select max(column) from parent table very slow  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-performance
>>>> query on each child and a max on the set that is returned.
>>> It is not.  Feel free to submit a patch for planagg.c ...
>> I think my patch to pgbench may have set your expectations of me a bit
>> high ;)...
>
> Actually I think this is the perfect opportunity for you -- a patch that
> not only was absolutely unexpected, undiscussed, and posted without
> previous warning, but one that you were actually asked about!  And
> weren't you recently joking about giving Tom nightmares by sending
> patches to the optimizer?

Yeah, but Tom is getting up there a bit, and that might mean a heart
attack. Then what would we do? ;)

Joshua D. Drake


>
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/



pgsql-performance by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: select max(column) from parent table very slow
Next
From: "soni de"
Date:
Subject: Related to Inserting into the database from XML file