Re: Huge number of disk writes after migration to 8.1

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: Huge number of disk writes after migration to 8.1
Дата
Msg-id dqjb1h$1400$1@news.hub.org
обсуждение исходный текст
Ответ на Huge number of disk writes after migration to 8.1  (Marcin <migor@op.pl>)
Ответы Re: Huge number of disk writes after migration to 8.1  (Marcin <migor@op.pl>)
Список pgsql-general
On Tue, 17 Jan 2006, Marcin wrote:

>
> Playing with postgresql.conf I changed "stats_command_string" to off,
> reloaded config, and restarted connection from applications (the
> postgresql
> wasn't restarted). The write rate immediately drops down, and is now
> at 8000-9000 blocks per second (which is still 4-5 times more than in
> 8.0.3).
>

A similar problem was reported before:

        http://archives.postgresql.org/pgsql-admin/2005-12/msg00266.php

But we conclude that's not related to pgstats. See if that's related to
your situation.

Regards,
Qingqing



В списке pgsql-general по дате отправления:

Предыдущее
От:
Дата:
Сообщение: Distance calculation
Следующее
От: John Sidney-Woollett
Дата:
Сообщение: Re: Distance calculation