Re: Large aggregate query running out of memory in ExecutorState

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Large aggregate query running out of memory in ExecutorState
Дата
Msg-id 16761.1172871252@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Large aggregate query running out of memory in ExecutorState  (Casey Duncan <casey@pandora.com>)
Список pgsql-general
Casey Duncan <casey@pandora.com> writes:
> I have some nightly statisics queries that runs against a view which
> unions several large tables. Recently one of these queries started
> running into out of memory errors. This is on postgresql 8.1.8
> running on 32-bit Debian Linux.

What have you got work_mem set to, and what's the actual process size
limit the kernel is enforcing?  It looks to me like your query will
try to eat at least twice work_mem for the two COUNT DISTINCT operations.
Another issue is that the measurement of how much space is really being
used is not necessarily very accurate --- I don't recall exactly how
good 8.1 is about that, but it wouldn't surprise me too much if the
actual net memory demand was about twice as much again.

Anyway the short answer is probably "reduce work_mem".

            regards, tom lane

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

Предыдущее
От: dlivesay@covad.net
Дата:
Сообщение: Re: I'd love to know what the rest of this error message is.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: How often do I need to reindex tables?