Re: JOIN with inherited table ignores indexes

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Andreas Pflug <pgadmin@xxxxxxxxxxxxxxxxx>
Subject: Re: JOIN with inherited table ignores indexes
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Thu, 08 Jun 2006 12:06:25 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
Comments: In-reply-to Andreas Pflug <pgadmin@xxxxxxxxxxxxxxxxx> message dated "Thu, 08 Jun 2006 13:40:33 +0200"
In-reply-to: <44880CB1.90307@xxxxxxxxxxxxxxxxx>
References: <44880CB1.90307@xxxxxxxxxxxxxxxxx>

Andreas Pflug <pgadmin@xxxxxxxxxxxxxxxxx> writes:
> Any explanation for this horror?

Existing releases aren't smart about planning joins to inheritance
trees.  CVS HEAD is better...

			regards, tom lane

Follow-Ups:
- Re: JOIN with inherited table ignores indexes
  - From: Andreas Pflug

References:
- JOIN with inherited table ignores indexes
  - From: Andreas Pflug

Prev by Date: Re: Regarding pg_dump utility
Next by Date: Re: Regarding pg_dump utility
Previous by thread: Re: JOIN with inherited table ignores indexes
Next by thread: Re: JOIN with inherited table ignores indexes
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux