From: | Maxim Boguk <maxim(dot)boguk(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Why checkpoint_timeout had maximum value of 1h? |
Date: | 2012-03-29 10:57:53 |
Message-ID: | CAK-MWwR4DDGPLpC2Gw6e7R2+R_GWqfMONcRBj-AyQuqyqZfZHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi all,
Is there any real reason why checkpoint_timeout limited to 1hour?
In my case I have some replicas with WAL on SAS raid and PGDATA on SSD with
limited write endurance.
And I don't worry about possible long time recovery after power failure in
that case.
Whats more working dataset fill in shared buffers, so almost no dirty
buffers evictions by bgwriter or backends happened.
In that case having checkpoint_timeout=10hour could reduce amout of writes
on SSD by factor of 10, and increase planned ssd lifetime by the same
amount.
I would like to have ability to set checkpoint_timeout=high value
and (whats even better) checkpoint_timeout=0 - in that case checkpoint
happen when all checkpoint_segments were used.
Is there any serious drawbacks in that idea?
Is it safe to increase that limit in source and rebuild database? (9.0 and
9.1 case)
--
Maxim Boguk
Senior Postgresql DBA.
Phone RU: +7 910 405 4718
Phone AU: +61 45 218 5678
Skype: maxim.boguk
Jabber: maxim(dot)boguk(at)gmail(dot)com
LinkedIn profile: http://nz.linkedin.com/in/maximboguk
"If they can send one man to the moon... why can't they send them all?"
МойКруг: http://mboguk.moikrug.ru/
"People problems are solved with people.
If people cannot solve the problem, try technology.
People will then wish they'd listened at the first stage."
From | Date | Subject | |
---|---|---|---|
Next Message | Vick Khera | 2012-03-29 14:08:50 | Re: could not read block... how could I identify/fix |
Previous Message | Albert | 2012-03-29 09:43:02 | Re: user get notification when postgresql database updated |