Re: CREATE TABLE, load and freezing - Mailing list pgsql-hackers

From Florian Pflug
Subject Re: CREATE TABLE, load and freezing
Date
Msg-id 47C6BA59.2030505@gmail.com
Whole thread Raw
In response to Re: CREATE TABLE, load and freezing  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List 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 by date:

Previous
From: Jorgen Austvik - Sun Norway
Date:
Subject: Re: Buildfarm member gypsy_moth seems not to like alignment patch
Next
From: Andrew Dunstan
Date:
Subject: Re: Silly Newbie question