Re: select max(column) from parent table very slow

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: select max(column) from parent table very slow
Дата
Msg-id 44EF15F9.7040807@commandprompt.com
обсуждение исходный текст
Ответ на Re: select max(column) from parent table very slow  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: select max(column) from parent table very slow
Следующее
От: "soni de"
Дата:
Сообщение: Related to Inserting into the database from XML file