Re: Reseting statistics counters

Поиск
Список
Период
Сортировка
От Strahinja Kustudić
Тема Re: Reseting statistics counters
Дата
Msg-id CADKbJJW3W8n6MWh3qzxutAKo5Dx176X5iTzDo6xxM8n3y4Ro2g@mail.gmail.com
обсуждение исходный текст
Ответ на Reseting statistics counters  (Xenofon Papadopoulos <xpapad@gmail.com>)
Ответы Re: Reseting statistics counters  (Tomas Vondra <tv@fuzzy.cz>)
Список pgsql-performance
Sorry for the late reply, but as far as I know when you run pg_stat_reset() you should always run analyze manually of the database to populate the statistics.


Strahinja Kustudić
| Lead System Engineer | Nordeus


On Tue, Oct 1, 2013 at 1:50 PM, Xenofon Papadopoulos <xpapad@gmail.com> wrote:
If we reset the statistics counters using pg_stat_reset() will it affect the performance of the database? Eg are these the same statistics used by the planner?
Thanks


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

Предыдущее
От: Patrick Krecker
Дата:
Сообщение: General slowness when retrieving a relatively small number of rows
Следующее
От: Rogerio Pereira
Дата:
Сообщение: Query in cache