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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-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"
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2006-01-18 16:38:46 | Re: Huge number of disk writes after migration to 8.1 |
Previous Message | Tom Lane | 2006-01-18 16:19:31 | Re: [Fwd: Re: BUG #2168: 45.000.000 records too much?] |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-01-18 16:44:37 | Re: Huge number of disk writes after migration to 8.1 |
Previous Message | Tom Lane | 2006-01-18 15:20:30 | Re: Huge number of disk writes after migration to 8.1 |