Re: Some thoughts about i/o priorities and throttling vacuum

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: Some thoughts about i/o priorities and throttling vacuum
Дата
Msg-id
23321.1066406390@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: Some thoughts about i/o priorities and throttling vacuum "Stephen" <jleelim@xxxxxx.com>
Re: Some thoughts about i/o priorities and throttling vacuum Bruce Momjian <pgman@candle.pha.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum "Matthew T. O'Connor" <matthew@zeut.net>
Re: Some thoughts about i/o priorities and throttling vacuum Andrew Sullivan <andrew@libertyrms.info>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum Andrew Sullivan <andrew@libertyrms.info>
Re: Some thoughts about i/o priorities and throttling vacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Rod Taylor <rbt@rbt.ca>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Some thoughts about i/o priorities and throttling vacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum "Matthew T. O'Connor" <matthew@zeut.net>
Re: Some thoughts about i/o priorities and throttling vacuum Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Re: Some thoughts about i/o priorities and throttling vacuum "Matthew T. O'Connor" <matthew@zeut.net>
Re: Some thoughts about i/o priorities and throttling vacuum Alvaro Herrera <alvherre@dcc.uchile.cl>
Re: Some thoughts about i/o priorities and throttling vacuum Tom Lane <tgl@sss.pgh.pa.us>
Re: Some thoughts about i/o priorities and throttling vacuum Greg Stark <gsstark@mit.edu>
Re: Some thoughts about i/o priorities and throttling vacuum "Matthew T. O'Connor" <matthew@zeut.net>
Alvaro Herrera  writes:
> The trick to keep in mind is that the XID comparison functions use
> "modulo" operations, _but_ there are special "frozen" XIDs that are
> always "committed" -- that's why a VACUUM FREEZE would relieve the table
> forever from this problem.

> (At least this is how I understand it -- I could be totally wrong here)

No, that's exactly correct.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Matthew T. O'Connor
Дата:
FAQ