On 16.11.2013 20:49, Strahinja Kustudić wrote:
> 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.
Why?
There are two kinds of stats in the database - stats used by the planner
(commo
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 wrote:
> If we reset the stati
Hello
2013/10/1 Xenofon Papadopoulos
> 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
>
>
these statistics are used only for autovacuum, what I know. So you can
impact a
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
