Skip site navigation (1) Skip section navigation (2)

Re: Huge number of disk writes after migration to 8.1

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Marcin <migor(at)op(dot)pl>, pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: Huge number of disk writes after migration to 8.1
Date: 2006-01-18 16:34:19
Message-ID: 20060118163419.GA19933@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
Tom Lane wrote:

> Stats off and it's still bloating the file??
> 
> [ studies code... ]  I see the culprit: it's the pgstat_report_vacuum
> and pgstat_report_analyze routines that were added in 8.1.  Those send
> messages unconditionally, meaning that the collector will create table
> entries for every table during a database-wide vacuum, even with stats
> turned off.
> 
> This seems like a bad idea.  

Sorry, clearly my bug :-(

> Given the nature of what's counted, I think that treating these
> messages as "row level" stats would be appropriate.  Alvaro, what do
> you think?

Yeah, row level seems appropiate for what we use it.  I'll take care of
it, unless you want to do it.

-- 
Alvaro Herrera                                http://www.PlanetPostgreSQL.org
<inflex> really, I see PHP as like a strange amalgamation of C, Perl, Shell
<crab> inflex: you know that "amalgam" means "mixture with mercury",
       more or less, right?
<crab> i.e., "deadly poison"

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-01-18 16:38:46
Subject: Re: Huge number of disk writes after migration to 8.1
Previous:From: Tom LaneDate: 2006-01-18 16:19:31
Subject: Re: [Fwd: Re: BUG #2168: 45.000.000 records too much?]

pgsql-patches by date

Next:From: Tom LaneDate: 2006-01-18 16:44:37
Subject: Re: Huge number of disk writes after migration to 8.1
Previous:From: Tom LaneDate: 2006-01-18 15:20:30
Subject: Re: Huge number of disk writes after migration to 8.1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group