Postgres Pro
Downloads
Home   >   mailing lists

Re: Out of memory on SELECT (from sort?) in 8.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Out of memory on SELECT (from sort?) in 8.3
Date
Msg-id 8902.1221451949@sss.pgh.pa.us
Whole thread Raw
In response to Out of memory on SELECT (from sort?) in 8.3  ("Matt Magoffin" <postgresql.org@msqr.us>)
Responses Re: Out of memory on SELECT (from sort?) in 8.3
List pgsql-general
Tree view 
"Matt Magoffin" <postgresql.org@msqr.us> writes:
> I have a SELECT query that causes an out-of-memory error on my production
> Postgres 8.3 server.

8.3.which, and what exactly is the query and its EXPLAIN plan?

> I believe the culprit is from the sort in the query,

No, the problem seems to be here

>       ExecutorState: 841031232 total in 51159 blocks; 1712232 free (56
> chunks); 839319000 used

and it's impossible to guess what that's about without a lot more
details than you provided.  The sort's only eating 28MB:

>         TupleSort: 28303408 total in 13 blocks; 5346944 free (14 chunks);
> 22956464 used

            regards, tom lane

pgsql-general by date:

Previous
From: "Matt Magoffin"
Date:
Subject: Out of memory on SELECT (from sort?) in 8.3
Next
From: Craig Ringer
Date:
Subject: Re: plpgsql return select from multiple tables