| 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 |