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)
Список
Дерево обсуждения
memory usage of group by select Anthony <osm@inbox.org>
Re: memory usage of group by select Anthony <osm@inbox.org>
Re: memory usage of group by select Alvaro Herrera <alvherre@commandprompt.com>
Re: memory usage of group by select Tom Lane <tgl@sss.pgh.pa.us>
Re: memory usage of group by select Anthony <osm@inbox.org>
On Tue, Dec 29, 2009 at 3:41 PM, Anthony <osm@inbox.org> wrote:
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?
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 по дате отправления
