Re: [HACKERS] raised checkpoint limit & manual checkpoint

I would suggest that a good complementary feature would be to allow a manual checkpoint to run over a period of time, say something like: CHECKPOINT OVER '10 hours'; That would target to complete after this period (whether it succeeds or not is another issue) instead of going as fast as

Re: [HACKERS] raised checkpoint limit & manual checkpoint

On Sat, Sep 24, 2016 at 12:12 PM, Fabien COELHO wrote: > > Hello, > > The checkpoint time limit has just been raised to one day after a discussion > started by Andres Freund: > > https://www.postgresql.org/message-id/20160202001320.GP8743%40awork2.anarazel.de > > I would have

[HACKERS] raised checkpoint limit & manual checkpoint

Hello, The checkpoint time limit has just been raised to one day after a discussion started by Andres Freund: https://www.postgresql.org/message-id/20160202001320.GP8743%40awork2.anarazel.de I would have gone further up, say one week or even one month, but I think that this new limit is an