AW: Coping with huge deferred-trigger lists - Mailing list pgsql-hackers

From Zeugswetter Andreas SB
Subject AW: Coping with huge deferred-trigger lists
Date
Msg-id 11C1E6749A55D411A9670001FA6879633682C2@sdexcsrv1.f000.d0188.sd.spardat.at
Whole thread Raw
Responses Re: AW: Coping with huge deferred-trigger lists  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Alexander Klimov
Date:
Subject: Re: Is `#!/bin/sh' configurable?
Next
From: Michael Meskes
Date:
Subject: What happened to function textpos()?