On 2010-10-31, Peter Neal wrote:
> --0016363b85c479ce9d0493f14f93
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi,
>
> I have two tables (A and B), which are partitioned (A1, A2... B1, B2...) for
> easy deletion of old records. They are linked by a bigint column "id", which
> is defined as a
On Sun, Oct 31, 2010 at 6:35 PM, Peter Neal wrote:
> Is there any way I can explain this to postgres? When I query the parent
> table of the partitions, "SELECT * from A, B where a.id=b.id;", the planner
> does a sequential scan on A, A1, A2, ... an index scan on B, B1, B2, ...
> then a nested lo
Hi,
I have two tables (A and B), which are partitioned (A1, A2... B1, B2...) for
easy deletion of old records. They are linked by a bigint column "id", which
is defined as a foreign key in each B partition referencing the
corresponding A partition. Many rows in B1 can reference a single row in A1.
