Re: How to speedup CHECKPOINTs?

Поиск
Список
Период
Сортировка
От Dmitry Koterov
Тема Re: How to speedup CHECKPOINTs?
Дата
Msg-id d7df81620703290006p79f44456h3108c4454cdad61a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to speedup CHECKPOINTs?  (Joseph S <jks@selectacast.net>)
Список pgsql-general
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 по дате отправления:

Предыдущее
От: Ferdinand Gassauer
Дата:
Сообщение: coalesce for null AND empty strings
Следующее
От: "Billy Gray"
Дата:
Сообщение: Some encoding trouble via libpq