Re: Improvement of procArray.xmin for VACUUM
От
Bruce Momjian
Тема
Re: Improvement of procArray.xmin for VACUUM
Дата
Msg-id
200703271319.l2RDJeC03261@momjian.us
Ответ на
Re: Improvement of procArray.xmin for VACUUM (Tom Lane)
Список
Дерево обсуждения
Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Alvaro Herrera <alvherre@commandprompt.com>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM "Simon Riggs" <simon@2ndquadrant.com>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Heikki Linnakangas <heikki@enterprisedb.com>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM "Simon Riggs" <simon@2ndquadrant.com>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Gregory Stark <stark@enterprisedb.com>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Bruce Momjian <bruce@momjian.us>
Re: Improvement of procArray.xmin for VACUUM Gregory Stark <stark@enterprisedb.com>
Re: Improvement of procArray.xmin for VACUUM Tom Lane <tgl@sss.pgh.pa.us>
Re: Improvement of procArray.xmin for VACUUM Gregory Stark <stark@enterprisedb.com>
Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> Uh, no, that's not very clear. A long-running transaction will be a > >> VACUUM bottleneck because of its own XID, never mind its xmin. > > > Well, my secondary addition was to start MyProc->xmin with the current > > xid counter, rather than your own xid. > > Don't tell me you seriously believe that would work. I do. Please tell me why it will not. -- Bruce Momjian http://momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
В списке pgsql-patches по дате отправления
От: stark
Дата: