From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: out of memory error |
Date: | 2011-07-03 12:41:32 |
Message-ID: | 4E10637C.1040408@compulab.co.il |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 07/03/2011 01:00 PM, Geoffrey Myers wrote:
> We have a process that we successfully ran on virtually identical
> databases. The process completed fine on a machine with 8 gig of
> memory. The process fails when run on another machine that has 16 gig
> of memory with the following error:
>
> out of memory for query result
>
> How is this possible?
Look at the diff on the postgresql.conf from the two machines.
>
> The databases are almost identical. By that I mean, the database that
> the process completed properly is a dump of the database from the
> machine where it failed. There is about a week's more data in the
> database where the process failed. The whole database only takes up
> about 13 gig of disk space.
>
> Any clues would be appreciated.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Ringer | 2011-07-03 12:49:56 | Re: out of memory error |
Previous Message | Geoffrey Myers | 2011-07-03 10:00:48 | out of memory error |