Re: [GENERAL] ERROR: Memory exhausted in AllocSetAlloc(188)

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 majordomo@postgresql.org
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073