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

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: Scaling up deferred unique checks and the after trigger queue
Дата
Msg-id 8e2dbb700910191007u3bd1d763w94c8960add24f728@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Scaling up deferred unique checks and the after trigger queue  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: Controlling changes in plpgsql variable resolution
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Rejecting weak passwords