Skip site navigation (1) Skip section navigation (2)

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: 2010-02-26 06:29:22
Message-ID: 1418021012.20100226072922@erwied.eu (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Devrim GÜNDÜZDate: 2010-02-26 06:42:21
Subject: Re: bgwriter, checkpoints, curious (seeing delays)
Previous:From: Tory M BlueDate: 2010-02-26 06:20:38
Subject: Re: bgwriter, checkpoints, curious (seeing delays)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group