Re: Vacuum/visibility is busted

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Vacuum/visibility is busted
Дата
Msg-id CAMkU=1wO_Pt=mCYyu9gv_eS2KKm86v8_xEbR31KM5nnY3Oheag@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Vacuum/visibility is busted  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Ответы Re: Vacuum/visibility is busted  (Andres Freund <andres@2ndquadrant.com>)
Re: Vacuum/visibility is busted  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Vacuum/visibility is busted  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Vacuum/visibility is busted  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
On Thu, Feb 7, 2013 at 10:09 AM, Pavan Deolasee
<pavan.deolasee@gmail.com> wrote:
>
> Right. I don't have the database handy at this moment, but earlier in
> the day I ran some queries against it and found that most of the
> duplicates which are not accessible via indexes have xmin very close
> to 2100345903. In fact, many of them are from a consecutive range.

Does anyone have suggestions on how to hack the system to make it
fast-forward the current transaction id? It would certainly make
testing this kind of thing faster if I could make transaction id
increment by 100 each time a new one is generated.  Then wrap-around
could be approached in minutes rather than hours.

Thanks,

Jeff



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Fast promote mode skips checkpoint at end of recovery.
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Vacuum/visibility is busted