Postgres Pro
Downloads
Home   >   mailing lists

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

From Dmitry Koterov
Subject Re: How to speedup CHECKPOINTs?
Date
Msg-id d7df81620703290006p79f44456h3108c4454cdad61a@mail.gmail.com
Whole thread Raw
In response to Re: How to speedup CHECKPOINTs?  (Joseph S <jks@selectacast.net>)
List pgsql-general
Tree view
No. Disk read activity is ALWAYS 0, the system has a lot of disk cache.

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.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-general by date:

Previous
From: Ferdinand Gassauer
Date:
Subject: coalesce for null AND empty strings
Next
From: "Billy Gray"
Date:
Subject: Some encoding trouble via libpq