Re: Checkpointer on hot standby runs without looking checkpoint_segments
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Florian Pflug <fgp@phlo.org>
Cc: Robert Haas <robertmhaas@gmail.com>, Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>, pgsql-hackers@postgresql.org, heikki.linnakangas@enterprisedb.com, masao.fujii@gmail.com
Date: 2012-06-08T17:43:47Z
Lists: pgsql-hackers
On 8 June 2012 18:01, Florian Pflug <fgp@phlo.org> wrote: >> What would be much better, IMHO, is if the number of retained >> segments could ratchet down when the system is idle, eventually >> reaching a state where we keep only one segment beyond the one >> currently in use. > > I'm a bit sceptical about this. It seems to me that you wouldn't actually > be able to do anything useful with the conserved space, since postgres > could re-claim it at any time. At which point it'd better be available, > or your whole cluster comes to a screeching halt... Agreed, I can't really see why you'd want to save space when the database is slow at the expense of robustness and reliability when the database speeds up. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services