Re: Reseting statistics counters - Mailing list pgsql-performance

From Strahinja Kustudić
Subject Re: Reseting statistics counters
Date
Msg-id CADKbJJW3W8n6MWh3qzxutAKo5Dx176X5iTzDo6xxM8n3y4Ro2g@mail.gmail.com
Whole thread Raw
In response to Reseting statistics counters  (Xenofon Papadopoulos <xpapad@gmail.com>)
Responses Re: Reseting statistics counters
List 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 by date:

Previous
From: Patrick Krecker
Date:
Subject: General slowness when retrieving a relatively small number of rows
Next
From: Rogerio Pereira
Date:
Subject: Query in cache