AW: Coping with huge deferred-trigger lists

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: AW: Coping with huge deferred-trigger lists
Date: 2001-05-10 08:24:22
Message-ID: 11C1E6749A55D411A9670001FA6879633682C2@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message 施銘斌 2001-05-10 08:46:48 Can PostgreSQL's Stored Procedure return a ReccordSet?
Previous Message Gilles DAROLD 2001-05-10 08:17:36 Re: Oracle to Pg tool