Re: pg_stat

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Nailah Ogeer <ogeer(at)cs(dot)queensu(dot)ca>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_stat
Date: 2003-11-06 23:28:21
Message-ID: 3FAAD915.7040605@bigfoot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Nailah Ogeer wrote:
> 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.

Regards
Gaetano Mendola

In response to

  • pg_stat at 2003-11-06 23:17:48 from Nailah Ogeer

Responses

  • Re: pg_stat at 2003-11-07 02:32:54 from Christopher Kings-Lynne

Browse pgsql-general by date

  From Date Subject
Next Message Craig O'Shannessy 2003-11-06 23:43:05 int8 primary keys still not using index without manual JDBC driver patch (7.4RC1)
Previous Message Darren Ferguson 2003-11-06 23:27:53 Re: create function for trigger question

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-11-06 23:41:55 stats collector causes shared-memory-block leakage
Previous Message Grant McLean 2003-11-06 23:28:09 Re: Deferrable triggers