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 по дате отправления: