| From: | "Dmitry Koterov" <dmitry(at)koterov(dot)ru> |
|---|---|
| To: | "Joseph S" <jks(at)selectacast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to speedup CHECKPOINTs? |
| Date: | 2007-03-29 07:06:46 |
| Message-ID: | d7df81620703290006p79f44456h3108c4454cdad61a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
No. Disk read activity is ALWAYS 0, the system has a lot of disk cache.
On 3/28/07, Joseph S <jks(at)selectacast(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Arai | 2007-03-29 07:13:09 | COPY command details |
| Previous Message | Stéphane Schildknecht | 2007-03-29 06:31:56 | Timestamp precision |