Re: Huge number of disk writes after migration to 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Huge number of disk writes after migration to 8.1
Date: 2006-01-18 19:39:41
Message-ID: 25039.1137613181@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Maybe the fact that the stat file is completely rewritten every 500 ms
> should be reconsidered, if in the future someone chooses to rewrite
> the stat system. We can reconsider this part then, as well.

Yeah, it's becoming pretty obvious that that design does not scale very
well. I don't immediately have any ideas about a better way though.

I am working on some marginal hacks like not writing more of the backend
activity strings than is needed, but it'd be nicer to think of a
different solution.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-01-18 20:12:14 Re: Huge number of disk writes after migration to 8.1
Previous Message Marcin 2006-01-18 19:36:27 Re: Huge number of disk writes after migration to 8.1

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2006-01-18 20:12:14 Re: Huge number of disk writes after migration to 8.1
Previous Message Marcin 2006-01-18 19:36:27 Re: Huge number of disk writes after migration to 8.1