Re: out of memory during query execution - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: out of memory during query execution
Date
Msg-id 20051221093137.GA4228@svana.org
Whole thread Raw
In response to Re: out of memory during query execution  (DANTE ALEXANDRA <ALEXANDRA.DANTE@BULL.NET>)
List pgsql-general
On Wed, Dec 21, 2005 at 10:22:05AM +0100, DANTE ALEXANDRA wrote:
> Hello,
>
> Thank you for all the answers I've got on this problem.
>
> Tom, I've checked this morning if the logfile contains lines like
> %s: %ld total in %ld blocks; %ld free (%ld chunks); %ld used
> and it is the case.

<snip>
> ExecutorState: 21586616 total in 25 blocks; 14624 free (33 chunks); 21571992 used
> HashTableContext: 8192 total in 1 blocks; 8128 free (2 chunks); 64 used
> HashBatchContext: 134152352 total in 22 blocks; 14859064 free (55434 chunks); 119293288 used
> HashTableContext: 8192 total in 1 blocks; 8128 free (0 chunks); 64 used
> HashBatchContext: 108527800 total in 16 blocks; 1016512 free (24 chunks); 107511288 used

These are by far the largest and seem to confirm that your total memory
usage is limited to not much more than 256MB, so what that other poster
said may be relevent. Whether that as reasonable amount for a hash
table to use in your context, I'll leave that to someone else...

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

pgsql-general by date:

Previous
From: DANTE ALEXANDRA
Date:
Subject: Re: out of memory during query execution
Next
From: DANTE ALEXANDRA
Date:
Subject: Re: out of memory during query execution