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? (Sample of `vmstat 1` at different points are good, if your OS supports that.) > any suggestion ? Read this page and post again with more detail: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin