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 по дате отправления