Re: Huge number of disk writes after migration to 8.1 - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: Huge number of disk writes after migration to 8.1
Date
Msg-id dqjb1h$1400$1@news.hub.org
Whole thread Raw
In response to Huge number of disk writes after migration to 8.1  (Marcin <migor@op.pl>)
Responses Re: Huge number of disk writes after migration to 8.1  (Marcin <migor@op.pl>)
List 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 by date:

Previous
From:
Date:
Subject: Distance calculation
Next
From: John Sidney-Woollett
Date:
Subject: Re: Distance calculation