Re: Scaling up deferred unique checks and the after trigger queue

Dean Rasheed <dean.a.rasheed@googlemail.com>

From: Dean Rasheed <dean.a.rasheed@googlemail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: pgsql-hackers@postgresql.org
Date: 2009-10-19T17:07:40Z
Lists: pgsql-hackers
2009/10/19 Robert Haas <robertmhaas@gmail.com>:
> On Mon, Oct 19, 2009 at 12:48 PM, Dean Rasheed
> <dean.a.rasheed@googlemail.com> wrote:
>> This is a WIP patch to replace the after-trigger queues with TID bitmaps
>> to prevent them from using excessive amounts of memory. Each round of
>> trigger executions is a modified bitmap heap scan.
>
> If the bitmap becomes lossy, how do you preserve the correct semantics?
>
> ...Robert
>

The idea is that it filters by the transaction ID and command ID of
modified rows to see what's been updated in the command(s) the trigger
is for...

 - Dean