| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Emmanuel Cecchet <manu(at)asterdata(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Herodotos Herodotou <Herodotos(dot)Herodotou(at)asterdata(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Eric Friedman <Eric(dot)Friedman(at)asterdata(dot)com>, John Cieslewicz <John(dot)Cieslewicz(at)asterdata(dot)com>, Dheeraj Pandey <Dheeraj(dot)Pandey(at)asterdata(dot)com>, "hero(at)cs(dot)duke(dot)edu" <hero(at)cs(dot)duke(dot)edu>, "nedyalko(at)cs(dot)duke(dot)edu" <nedyalko(at)cs(dot)duke(dot)edu> |
| Subject: | Re: Join optimization for inheritance tables |
| Date: | 2009-09-23 00:06:58 |
| Message-ID: | 1253664418.28462.123.camel@monkey-cat.sm.truviso.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, 2009-09-22 at 18:16 -0400, Emmanuel Cecchet wrote:
> If the partitioning implementation does not make progress (and does not
> make it for 8.5), don't you think that this could be an interesting
> contribution to consider for this release?
> I have put on the wiki
> (http://wiki.postgresql.org/wiki/Join_optimization_for_inheritance_tables)
> the results obtained so far and the use case where it is most used.
I think you mean that the planning time is in milliseconds, not seconds.
Also, you use "data" in a few places you meant "date".
The results seem good, and trading planning time for execution time
seems like a reasonable idea in the case of partitioned tables. We
already work harder planning when constraint_exclusion='partition', so
there is some precedent (I don't know if that's a good precedent to
follow or not).
How does it compare to using merge-append?
I haven't looked at the actual patch yet.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2009-09-23 00:35:36 | Re: Join optimization for inheritance tables |
| Previous Message | Peter Eisentraut | 2009-09-22 23:53:07 | Re: [rfc] unicode escapes for extended strings |