Re: Huge number of disk writes after migration to 8.1

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Huge number of disk writes after migration to 8.1
Дата
Msg-id 9008.1137597630@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Huge number of disk writes after migration to 8.1  (Marcin <migor@op.pl>)
Ответы Re: Huge number of disk writes after migration to 8.1  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Re: Huge number of disk writes after migration to 8.1  (Marcin <migor@op.pl>)
pg_restore error checking  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-bugs
Marcin <migor@op.pl> writes:
> On Tue, Jan 17, 2006 at 05:12:09PM -0500, Tom Lane wrote:
>> However, that's always been the case, so I don't understand
>> why your stats file is so much bigger in 8.1.  Have you changed your
>> vacuuming strategy at all since the 8.0 installation?  Perhaps row or
>> block statistics weren't enabled in the 8.0 installation and are now?

> The only change was the upgrade to 8.1. I run VACUUM FULL everyday, and
> double checked that it finished succesfully in last two days.
> The block and row statistics are disabled:
> stats_start_collector = on
> stats_command_string = off
> stats_block_level = off
> stats_row_level = off
> stats_reset_on_server_start = off

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.  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?

            regards, tom lane

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

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