| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] ERROR: Memory exhausted in AllocSetAlloc(188) |
| Date: | 2003-05-22 05:33:06 |
| Message-ID: | 20030522053306.GB2150@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2003-05-22 07:07:26 | Re: caching query results |
| Previous Message | Steve Lane | 2003-05-22 04:06:20 | Re: PRIMARY KEYS [somewhat OT] |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-05-22 05:37:43 | Re: [COMMITTERS] pgsql-server/src backend/commands/variable.c b ... |
| Previous Message | Tom Lane | 2003-05-22 05:24:37 | Re: [COMMITTERS] pgsql-server/src backend/commands/variable.c b ... |