Re: BUG #4721: All sub-tables incorrectly included in search plan for partitioned table - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #4721: All sub-tables incorrectly included in search plan for partitioned table
Date
Msg-id 15819.1237614240@sss.pgh.pa.us
Whole thread Raw
In response to BUG #4721: All sub-tables incorrectly included in search plan for partitioned table  ("Eric Thompson" <eric.thompson@salliemae.com>)
Responses Re: BUG #4721: All sub-tables incorrectly included in search plan for partitioned table
Re: BUG #4721: All sub-tables incorrectly included in search plan for partitioned table
List pgsql-bugs
"Eric Thompson" <eric.thompson@salliemae.com> writes:
> test=# -- remove any irrelevant constraint from the master table, and now
> the date partitioning works

Hmm.  Tracing through this, it seems your child tables have exactly 101
separate constraint clauses; removing one from the parent table gets it
down to 100.  Which is where the cutoff installed by this patch is:

http://archives.postgresql.org/pgsql-committers/2008-11/msg00146.php

That patch was in response to this complaint:

http://archives.postgresql.org/pgsql-general/2008-11/msg00446.php

I'm not entirely sure about a better approach; just moving the cutoff
around doesn't seem like it will do anything except change who's
complaining...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Eric Thompson"
Date:
Subject: BUG #4721: All sub-tables incorrectly included in search plan for partitioned table
Next
From: "Valter Cabecinha"
Date:
Subject: BUG #4723: I deleted the pg_xlog paste whwn i wanted to delet the pg_log paste