Search Postgresql Archives

Re: How to speedup CHECKPOINTs?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Joseph S" <jks@xxxxxxxxxxxxxxx>
Subject: Re: How to speedup CHECKPOINTs?
From: "CAJ CAJ" <pguser@xxxxxxxxx>
Date: Thu, 29 Mar 2007 09:56:57 -0700
Cc: "Dmitry Koterov" <dmitry@xxxxxxxxxx>, pgsql-general@xxxxxxxxxxxxxx
Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=SUd03ZSDmsZHSBS/GyggdHvN/iFiIOZndmgwZXIP9zoyXl69zPc6jwZp5JdoBqirodW3++FRisAQbgg7WbCkqIkeIF3HPPz0LYpiCOSjIhejnyAxm5WbM039K0/E3lmYF8YEPxCU6j83oWElkDB7Il+CBekJ2nvlDnZ48y2AAuQ=
In-reply-to: <460AC7CF.20901@xxxxxxxxxxxxxxx>
References: <d7df81620703280705sc4fd8ecic43c10ac7ceb978@xxxxxxxxxxxxxx> <460AC7CF.20901@xxxxxxxxxxxxxxx>

On 3/28/07, Joseph S <jks@xxxxxxxxxxxxxxx> 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?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to speedup CHECKPOINTs?
  - From: Dmitry Koterov

References:
- How to speedup CHECKPOINTs?
  - From: Dmitry Koterov
- Re: How to speedup CHECKPOINTs?
  - From: Joseph S

Prev by Date: Re: RES: Order by behaviour
Next by Date: Mentor
Previous by thread: Re: How to speedup CHECKPOINTs?
Next by thread: Re: How to speedup CHECKPOINTs?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux