Re: CREATE TABLE, load and freezing

Поиск
Список
Период
Сортировка
От Florian Pflug
Тема Re: CREATE TABLE, load and freezing
Дата
Msg-id 47C6BA59.2030505@gmail.com
обсуждение исходный текст
Ответ на Re: CREATE TABLE, load and freezing  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-hackers
ITAGAKI Takahiro wrote:
>> Without this, very large read-only tables would require one round of
>> complete freezing if there are lot of transactional activities in the other parts
>> of the database. And when that happens, it would generate lots of unnecessary
>> IOs on these large tables.
> 
> To make things worse, the freezing day comes at once because the first restore
> is done in a single or near transactions; The wraparound timings of many
> tables are aligned at the same time. Freezing copy will be the solution.

Hm.. Couldn't we eliminate that particular concern easily by adding some 
randomness to the freeze_age?

regards, Florian Pflug



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

Предыдущее
От: Jorgen Austvik - Sun Norway
Дата:
Сообщение: Re: Buildfarm member gypsy_moth seems not to like alignment patch
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Silly Newbie question