"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > Silvio Brandani <silvio.brandani@xxxxxxxxxxx> wrote: >> a query on our production database give following errror: >> >> 2010-08-05 10:52:40 CEST [12106]: [278-1] ERROR: out of memory >> 2010-08-05 10:52:40 CEST [12106]: [279-1] DETAIL: Failed on >> request of size 48. > What query? On what OS? Is this a 32-bit or 64-bit build of > PostgreSQL? How long does it run before failing. What does memory > usage look like before and during the run? Also, out-of-memory should result in a memory usage map getting dumped to the postmaster log. That would be useful to see too. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin