Re: [PERFORM] JOIN with inherited table ignores indexes

Tom Lane wrote: Andreas Pflug <[EMAIL PROTECTED]> 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

Re: [PERFORM] JOIN with inherited table ignores indexes

Andreas Pflug <[EMAIL PROTECTED]> writes: > Any explanation for this horror? Existing releases aren't smart about planning joins to inheritance trees. CVS HEAD is better... regards, tom lane ---(end of broadcast)--- TIP 3:

Re: [PERFORM] JOIN with inherited table ignores indexes

On Thu, Jun 08, 2006 at 01:40:33PM +0200, Andreas Pflug wrote: > I have this table setup on a 8.1.4 server: > > pj_info_attach(attachment_nr, some more cols) -- index, 50k rows > pj_info_attach_compressable() INHERITS (pj_info_attach) -- index, 1M rows > pj_info_attach_not_compressable() INHERITS