Re: bgwriter, checkpoints, curious (seeing delays)

From: Jochen Erwied
Subject: Re: bgwriter, checkpoints, curious (seeing delays)
Date: ,
Msg-id: 1418021012.20100226072922@erwied.eu
(view: Whole thread, Raw)
In response to: Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue)
List: pgsql-performance

Tree view

bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
 Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
  Re: bgwriter, checkpoints, curious (seeing delays)  (Jochen Erwied, )
 Re: bgwriter, checkpoints, curious (seeing delays)  (Devrim GÜNDÜZ, )
  Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
   Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
    Re: bgwriter, checkpoints, curious (seeing delays)  (Greg Smith, )
   Re: bgwriter, checkpoints, curious (seeing delays)  (Devrim GÜNDÜZ, )
    Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
  Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
   Re: bgwriter, checkpoints, curious (seeing delays)  ("Jorge Montero", )
    Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
     Re: bgwriter, checkpoints, curious (seeing delays)  (Robert Haas, )
   Re: bgwriter, checkpoints, curious (seeing delays)  ("Fernando Hevia", )
 Re: bgwriter, checkpoints, curious (seeing delays)  ("Kevin Grittner", )
  Re: bgwriter, checkpoints, curious (seeing delays)  (Tory M Blue, )
   Re: bgwriter, checkpoints, curious (seeing delays)  (Ben Chobot, )

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:      +49-208-38800-18, FAX: -19
Sauerbruchstr. 17 |   work:   +49-2151-7294-24, FAX: -50
D-45470 Muelheim  | mobile:        +49-173-5404164



pgsql-performance by date:

From: Richard Huxton
Date:
Subject: Re: Multiple data base on same server
From: Richard Huxton
Date:
Subject: Re: Multiple data base on same server