| From: | "Simon Riggs" <simon(at)2ndquadrant(dot)com> |
|---|---|
| To: | "Andreas Kostyrka" <andreas(at)kostyrka(dot)org> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: partitioned table performance |
| Date: | 2006-10-30 22:46:43 |
| Message-ID: | 1162248403.11568.370.camel@silverbirch.site |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Mon, 2006-10-30 at 22:58 +0100, Andreas Kostyrka wrote:
> Am Montag, den 30.10.2006, 08:18 +0000 schrieb Simon Riggs:
> > On Sun, 2006-10-29 at 00:28 +0200, Andreas Kostyrka wrote:
> >
> > > Any ideas how to make the optimizer handle partitioned tables more
> > > sensible?
> >
> > Yes, those are known inefficiencies in the current implementation which
> > we expect to address for 8.3.
>
> Any ideas to force the current optimizer to do something sensible?
Brute force & ignorance: PL/pgSQL
Perhaps some other domain knowledge might help you shorten the search?
Thats all for now. It's not a minor fixup and nobody had time to fix
that for 8.2 since other fish were bigger.
--
Simon Riggs
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Leif Mortenson | 2006-10-31 04:04:12 | Index ignored on column containing mostly 0 values |
| Previous Message | Andreas Kostyrka | 2006-10-30 21:58:15 | Re: partitioned table performance |