Bruce Momjian wrote:
> Do you mean stats_command_string? I have seen degradation in using that
Yes, I meant stats_command_string, sorry for my stupid mistake.
> and am working on a patch for 8.2 to fix it.
That's nice, because it's very helpful.
Thanks for response,
--
Marcin
---
Do you mean stats_command_string? I have seen degradation in using that
and am working on a patch for 8.2 to fix it.
---
Marcin wrote:
> Qingqing Zhou wrote:
> > A similar problem was reported before:
> >
> > http:
Qingqing Zhou wrote:
> 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.
Unfortunately, I don't think so. The 8.0.3 run just fine. And I
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 (whi
Marcin <[EMAIL PROTECTED]> writes:
> It seems that some changes to stats collector introduced in 8.1 are
> now eating my CPU power, and probably also the (I)/O bandwidth. :(
Yeah, something wrong there :-(. What did you say your platform was
exactly? Would you strace the collector process, and s
On Mon, Jan 16, 2006 at 05:09:18PM -0500, Qingqing Zhou wrote:
> AFAICS the difference maybe related to this between 8.0 and 8.1 is the
> introduction of autovacuum. But seems you didn't turn it on. Do you observed
> only writes increased or both read/write? If the latter, that might be an
> uno
"Marcin" <[EMAIL PROTECTED]> wrote
>
> I suffer from huge increase in number of disk writes after migration
> from 8.0.3 to 8.1.2. The average number of sectors written increased 10
> times and transfer stays at 20MB of writes per second during work hours
> (with 20% cpu time wasted in iowait). Th
Hi,
I suffer from huge increase in number of disk writes after migration
from 8.0.3 to 8.1.2. The average number of sectors written increased 10
times and transfer stays at 20MB of writes per second during work hours
(with 20% cpu time wasted in iowait). The number of queries lasting more
than 300m