Re: 9.5: Better memory accounting, towards memory-bounded HashAgg

Поиск
Список
Период
Сортировка
Искать
От
Jeff Davis
Тема
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg
Дата
Msg-id
1407703816.6623.2.camel@jeff-desktop
Ответ на
Список
Дерево обсуждения
9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Robert Haas <robertmhaas@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg "Tomas Vondra" <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Robert Haas <robertmhaas@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Robert Haas <robertmhaas@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tom Lane <tgl@sss.pgh.pa.us>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Simon Riggs <simon@2ndQuadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Andres Freund <andres@2ndquadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Peter Geoghegan <pg@heroku.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Peter Geoghegan <pg@heroku.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Janes <jeff.janes@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Michael Paquier <michael.paquier@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Michael Paquier <michael.paquier@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Michael Paquier <michael.paquier@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Andres Freund <andres@2ndquadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Andres Freund <andres@2ndquadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Simon Riggs <simon@2ndQuadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Simon Riggs <simon@2ndQuadrant.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Tomas Vondra <tv@fuzzy.cz>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Robert Haas <robertmhaas@gmail.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Jeff Davis <pgsql@j-davis.com>
Re: 9.5: Better memory accounting, towards memory-bounded HashAgg Peter Geoghegan <pg@heroku.com>
On Fri, 2014-08-08 at 01:16 -0700, Jeff Davis wrote:
> Either way, it's better to be conservative. Attached is a version of the
> patch with opt-in memory usage tracking. Child contexts inherit the
> setting from their parent.

There was a problem with the previous patch: the parent was unlinked
before the delete_context method was called, which meant that the
parent's memory was not being decremented.

Attached is a fix. It would be simpler to just reorder the operations in
MemoryContextDelete, but there is a comment warning against that. So, I
pass the old parent as an argument to the delete_context method.

Regards,
	Jeff Davis

В списке pgsql-hackers по дате отправления
От: Claudio Freire
Дата:
Сообщение: Re: Minmax indexes
От: Jeff Davis
Дата:
Сообщение: 9.5: Memory-bounded HashAgg
FAQ