Re: Improvement of procArray.xmin for VACUUM

Поиск
Список
Период
Сортировка
Искать
От
Bruce Momjian
Тема
Re: Improvement of procArray.xmin for VACUUM
Дата
Msg-id
200703271319.l2RDJeC03261@momjian.us
Ответ на
Список
Дерево обсуждения
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
Дата:
От: Bruce Momjian
Дата:
FAQ