AW: Coping with huge deferred-trigger lists

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Coping with huge deferred-trigger lists
Дата
Msg-id 11C1E6749A55D411A9670001FA6879633682C2@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Ответы Re: AW: Coping with huge deferred-trigger lists  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Perhaps instead
> of storing each and every trigger-related tuple in memory, we only need
> to store one value per affected table: the lowest CTID of any tuple
> that we need to revisit for deferred-trigger purposes.  At the end of
> the transaction, scan forward from that point to the end of the table,
> looking for tuples that were inserted by the current xact.

I thought that this current placing of new rows at end of file is subject to 
change soon (overwrite smgr) ?

I thus think it would be better to remember all ctids per table.
The rest imho sounds great.

Andreas


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alexander Klimov
Дата:
Сообщение: Re: Is `#!/bin/sh' configurable?
Следующее
От: Michael Meskes
Дата:
Сообщение: What happened to function textpos()?