On 2019-Mar-14, Robert Haas wrote: > On Thu, Mar 14, 2019 at 3:36 PM Alvaro Herrera <alvhe...@2ndquadrant.com> > wrote:
> > In any case, since the RI > > queries are run via SPI, any unnecessary partitions should get pruned by > > partition pruning based on each partition's constraint. So I'm not so > > certain that this is a problem worth spending much time/effort/risk of > > bugs on. > > I doubt that partition pruning would just automatically DTRT in a case > like this, but if I'm wrong, great! Uh, it was you that came up with the partition pruning system, so of course it DsTRT. I did test (some of?) the queries issued by ri_triggers with partitioned tables on the PK side, and indeed it seemed to me that partitions were being pruned at the right times. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services