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(at)postgresql(dot)org
>

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