Re: memory usage of group by select

Поиск
Список
Период
Сортировка
От Anthony
Тема Re: memory usage of group by select
Дата
Msg-id 71cd4dd90912291243k5e7e80b1lb83770eb69590417@mail.gmail.com
обсуждение исходный текст
Ответ на memory usage of group by select  (Anthony <osm@inbox.org>)
Ответы Re: memory usage of group by select  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
On Tue, Dec 29, 2009 at 3:41 PM, Anthony <osm@inbox.org> wrote:
I'm running a group by query on a table with over a billion rows and my memory usage is seemingly growing without bounds.  Eventually the mem usage exceeds my physical memory and everything starts swapping.

I guess I didn't ask my question.  Is this expected behavior?  Is there any way for me to adjust my settings to avoid using so much memory?

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Planner Row Estimate with Function
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: DDL commands take forever