Обсуждение: Re: [HACKERS] Remove lower limit on checkpoint_timeout?

Hello Andres,

> for testing - like yesterday's 6ef2eba3f - it's annoying that
> checkpoint_timeout has 30s minimum. I've now locally patched that to be
> 1s a significant number of times.
>
> While it's not a particularly good idea to set it to 1s on a production
> system, I don't see why we need to prevent that. It's not like 30s is
> likely to be a good idea either.
>
> Hence I'd like to set the lower limit to 1s.

My 0.02€:

I have also resorted to reduce this limit in order to reduce latency and 
avoid postgres freezing on checkpoints, before checkpoint buffers where 
sorted. I think I may have tried down to 0.1s which involved some changes, 
and it worked quite well for the purpose.

So basically I would also be in favor to reduce the lower limit down to 1 
second, maybe with a warning output when set to low values, say under 1 
minute, as you propose.

-- 
Fabien.