Re: Freezing without write I/O

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Freezing without write I/O
Дата
Msg-id 20130530210611.GC4715@momjian.us
обсуждение исходный текст
Ответ на Freezing without write I/O  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: Freezing without write I/O
Список pgsql-hackers
On Thu, May 30, 2013 at 04:33:50PM +0300, Heikki Linnakangas wrote:
> This would also be the first step in allowing the clog to grow
> larger than 2 billion transactions, eliminating the need for
> anti-wraparound freezing altogether. You'd still want to truncate
> the clog eventually, but it would be nice to not be pressed against
> the wall with "run vacuum freeze now, or the system will shut down".

Keep in mind that autovacuum_freeze_max_age is 200M to allow faster clog
truncation.  Does this help that?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Vacuum, Freeze and Analyze: the big picture
Следующее
От: Amit Langote
Дата:
Сообщение: Re: Behavior of a pg_trgm index for 2 (or < 3) character LIKE queries