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