Re: why partition pruning doesn't work? - Mailing list pgsql-hackers

From Robert Haas
Subject Re: why partition pruning doesn't work?
Date
Msg-id CA+TgmoajU5mPAvgGqST_iiW6P-Y2T3mAmSfCAw2GEtYi0KQCJg@mail.gmail.com
Whole thread Raw
In response to Re: why partition pruning doesn't work?  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: why partition pruning doesn't work?
List pgsql-hackers
On Thu, Jun 14, 2018 at 7:23 AM, David Rowley
<david.rowley@2ndquadrant.com> wrote:
> However, I only spent about 10 mins looking into this, there may be
> some giant holes in the idea.  It would need much more research.

It kind of flies in the face of the idea that a RangeTblEntry is just
a node that can be freely copied around, serialized and deserialized,
etc.

I think it would be better to keep the pointer in the RelOptInfo in
the planner and in the EState or PlanState in the executor.  Those are
things we don't think can be copied, serialized, etc.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Marina Polyakova
Date:
Subject: Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors
Next
From: Alexander Korotkov
Date:
Subject: Re: Locking B-tree leafs immediately in exclusive mode