| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Sriram Dandapani <sdandapani(at)counterpane(dot)com>, "Pgsql-Performance (E-mail)" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: select max(column) from parent table very slow |
| Date: | 2006-08-25 15:23:37 |
| Message-ID: | 44EF15F9.7040807@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | soni de | 2006-08-25 15:53:38 | Related to Inserting into the database from XML file |
| Previous Message | Alvaro Herrera | 2006-08-25 14:45:30 | Re: select max(column) from parent table very slow |