Re: pg_stat

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: pg_stat
Дата
Msg-id 3FAB0456.8010708@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: pg_stat  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-hackers
>> Just wondering how often the stats collector resets it self. Is this a
>> parameter i can change?
> 
> 
> At my knowledge each time that you do an analyze on
> your db your statistics are changed ( are not incremental
> I mean), anyway you can set to reset statistics at the
> start of postgres.

I think you're mixed up there.  Stats collector is totally different thing.

The stats collector is never reset.  You can reset it manually by going:

select pg_stat_reset();

And you can specify in the postgresql.conf that it should be reset on 
server restart if you like.

Chris




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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: OpenServer 5.0.7: setsockopt(TCP_NODELAY)?
Следующее
От: Robert Treat
Дата:
Сообщение: Re: [pgsql-www] Changes to Contributor List