Postgres Pro
Downloads
Home   >   mailing lists

Re: How to speedup CHECKPOINTs? - Mailing list pgsql-general

From CAJ CAJ
Subject Re: How to speedup CHECKPOINTs?
Date
Msg-id 467669b30703290956i855e083l22c172882e37ba03@mail.gmail.com
Whole thread Raw
In response to Re: How to speedup CHECKPOINTs?  (Joseph S <jks@selectacast.net>)
Responses Re: How to speedup CHECKPOINTs?  ("Dmitry Koterov" <dmitry@koterov.ru>)
List pgsql-general
Tree view


On 3/28/07, Joseph S <jks@selectacast.net> wrote:
Dmitry Koterov wrote:

> And the general question - why SELECT queries slowdown  during the
> CHECKPOINT? I thought that Postgres is a version-based database and read
> queries are never blocked...

Because the disk is busy.


Is your pg_xlog on a separate disk?




pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: RES: Order by behaviour
Next
From: Bob Pawley
Date:
Subject: Mentor