Re: JOIN with inherited table ignores indexes

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: JOIN with inherited table ignores indexes
Date: 2006-06-08 16:42:25
Message-ID: 44885371.5020201@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane wrote:
> Andreas Pflug <pgadmin(at)pse-consulting(dot)de> writes:
>
>>Any explanation for this horror?
>
>
> Existing releases aren't smart about planning joins to inheritance
> trees.

Using a view that UNIONs SELECT .. ONLY as replacement for the parent
table isn't any better. Is that improved too?

> CVS HEAD is better...

Customers like HEAD versions for production purposes :-)

Regards,
Andreas

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Andrus 2006-06-08 18:53:17 Why date index is not used
Previous Message Alvaro Herrera 2006-06-08 16:38:38 Re: Regarding pg_dump utility