Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: bgwriter, checkpoints, curious (seeing delays)
- From: Jochen Erwied <jochen(at)pgsql-performance(dot)erwied(dot)eu>
- To: Tory M Blue <tmblue(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: bgwriter, checkpoints, curious (seeing delays)
- Date: Fri, 26 Feb 2010 07:29:22 +0100
- Message-id: <1418021012.20100226072922@erwied.eu> <text/plain>
Friday, February 26, 2010, 7:20:38 AM you wrote:
> "checkpoint_completion_target (floating point)
> interesting that it's a .5 second default setting and I'm seeing
> exactly that .5 second delay.
It's not an exact time, but a multiplier to 'checkpoint_timeout'. So a
setting of .5 with a timeout of 300 seconds means a checkpoint should be
completed after 300*0.5 = 150 seconds.
--
Jochen Erwied | home: jochen(at)erwied(dot)eu +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 | work: joe(at)mbs-software(dot)de +49-2151-7294-24, FAX: -50
D-45470 Muelheim | mobile: jochen(dot)erwied(at)vodafone(dot)de +49-173-5404164
- References:
- bgwriter, checkpoints, curious (seeing delays)
- From: Tory M Blue
- Re: bgwriter, checkpoints, curious (seeing delays)
- From: Tory M Blue
- bgwriter, checkpoints, curious (seeing delays)
- Prev by Date: Re: bgwriter, checkpoints, curious (seeing delays)
- Next by Date: Re: bgwriter, checkpoints, curious (seeing delays)
- Previous by thread: Re: bgwriter, checkpoints, curious (seeing delays)
- Next by thread: Re: bgwriter, checkpoints, curious (seeing delays)
- Indexes: