Gregory Stark <stark@enterprisedb.com> writes:
> "Simon Riggs" <simon@2ndquadrant.com> writes:
>> We certainly need a TODO item for "improve RI checks during bulk
>> operations".
> I have a feeling it's already there. Hm. There's a whole section on RI
> triggers but the closest I see is this, neither of the links appear to refer
> to bulk operations:
> Optimize referential integrity checks
> http://archives.postgresql.org/pgsql-performance/2005-10/msg00458.php
> http://archives.postgresql.org/pgsql-hackers/2007-04/msg00744.php
No, both of those are talking about the same thing, ie, (1) making the
are-the-keys-unchanged optimization work when NULLs are present,
and (2) not testing for this case twice.
There's an entry in the Triggers section
* Add deferred trigger queue file
Right now all deferred trigger information is stored in backend memory. This could exhaust memory for very large
triggerqueues. This item involves dumping large queues into files.
but as already noted, this is a pretty myopic answer (at least for
RI triggers).
regards, tom lane