Re: Scaling up deferred unique checks and the after trigger queue - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Scaling up deferred unique checks and the after trigger queue
Date
Msg-id 8e2dbb700910191007u3bd1d763w94c8960add24f728@mail.gmail.com
Whole thread Raw
In response to Re: Scaling up deferred unique checks and the after trigger queue  (Robert Haas <robertmhaas@gmail.com>)
List 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


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Controlling changes in plpgsql variable resolution
Next
From: Tom Lane
Date:
Subject: Re: Rejecting weak passwords