Re: Huge number of disk writes after migration to 8.1

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Huge number of disk writes after migration to 8.1
Дата
Msg-id 20060118163419.GA19933@surnet.cl
обсуждение исходный текст
Ответ на Re: Huge number of disk writes after migration to 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Huge number of disk writes after migration to 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Huge number of disk writes after migration to 8.1  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
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"

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [Fwd: Re: BUG #2168: 45.000.000 records too much?]
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Huge number of disk writes after migration to 8.1