Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-18 Thread Marcin
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 ---

Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-18 Thread Bruce Momjian
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:

Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-17 Thread Marcin
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

Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-17 Thread Qingqing Zhou
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

Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-17 Thread Tom Lane
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

Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-17 Thread Marcin
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

Re: [GENERAL] Huge number of disk writes after migration to 8.1

2006-01-16 Thread Qingqing Zhou
"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

[GENERAL] Huge number of disk writes after migration to 8.1

2006-01-16 Thread Marcin
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