We already have this TODO item: * Add deferred trigger queue file (Jan)
--------------------------------------------------------------------------- Alvaro Herrera wrote: > On Wed, May 21, 2003 at 04:39:18PM -0400, Tom Lane wrote: > > > Each pending deferred-trigger action takes about 40 bytes + palloc > > overhead, probably 48 bytes altogether ... 48 * 35M comes to 1.68G, so > > that's exactly where your problem is. I'd suggest trying to commit the > > changes in smaller batches ... > > Probably it's time to add the TODO item: > > * Flush deferred trigger queue to disk when it grows too large > > The performance is probably awful, but better than failing with that > error anyway... > > -- > Alvaro Herrera (<alvherre[a]dcc.uchile.cl>) > Oh, oh, las chicas galacianas, lo har?n por las perlas, > ?Y las de Arrakis por el agua! Pero si buscas damas > Que se consuman como llamas, ?Prueba una hija de Caladan! (Gurney Halleck) > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])