Re: How to speedup CHECKPOINTs?

From: Joseph S <jks(at)selectacast(dot)net>
To: Dmitry Koterov <dmitry(at)koterov(dot)ru>
Subject: Re: How to speedup CHECKPOINTs?
Date: 2007-03-28 19:53:51
Message-ID: 460AC7CF.20901@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlos H. Reimer 2007-03-28 21:52:04 Order by behaviour
Previous Message Joseph S 2007-03-28 19:41:32 Re: redhat debug info