Re: out of memory during query execution

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: out of memory during query execution
Дата
Msg-id 20051221093137.GA4228@svana.org
обсуждение исходный текст
Ответ на Re: out of memory during query execution  (DANTE ALEXANDRA <ALEXANDRA.DANTE@BULL.NET>)
Список 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.

Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: DANTE ALEXANDRA
Дата:
Сообщение: Re: out of memory during query execution
Следующее
От: DANTE ALEXANDRA
Дата:
Сообщение: Re: out of memory during query execution