Hello everybody:
After I switch the slave to the master , I can not get the stats
information by the below sql and the pg_stat_reset() does not work on the New
Master,
And I vacuum by hand,it's still not work! I need some help.Could you give me
any idea?
the stat sql:
SELECT st.re
On Thursday, April 11, 2013, X.H.WANG <82661...@qq.com> wrote:
> Hello everybody:
>
> After I switch the slave to the master , I can not get the stats
> information by the below sql and the pg_stat_reset() does not work on the
> New Master,
> And I vacuum by hand,it's still not work! I ne
t;Vasilis Ventirozos";
Date: Thu, Apr 11, 2013 02:29 PM
To: "X.H.WANG"<82661...@qq.com>;
Cc: "pgsql-admin";
Subject: Re: [ADMIN] with PostgreSQL 9.1.9,the stats collector process is not
work!
On Thursday, April 11, 2013, X.H.WANG <82661...@qq.com&g
02:29 PM
> *To: * "X.H.----WANG"<82661...@qq.com>; **
> *Cc: * "pgsql-admin"; **
> *Subject: * Re: [ADMIN] with PostgreSQL 9.1.9,the stats collector process
> is not work!
>
>
>
> On Thursday, April 11, 2013, X.H.WANG <82661...@qq.com> wrote:
hanth Ranjalkar";
Date: Thu, Apr 11, 2013 10:31 PM
To: "X.H.WANG"<82661...@qq.com>;
Cc: "Vasilis Ventirozos";
"pgsql-admin";
Subject: Re: [ADMIN] with PostgreSQL 9.1.9,the stats collector process is not
work!
Would you mind providing more ins
o: * "X.H.WANG"<82661...@qq.com>; **
> *Cc: * "Vasilis Ventirozos"; "pgsql-admin"<
> pgsql-admin@postgresql.org>; **
> *Subject: * Re: [ADMIN] with PostgreSQL 9.1.9,the stats collector process
> is not work!
>
> *Would you mind providing more insi
: "Vasilis Ventirozos";
"pgsql-admin";
????: Re: [ADMIN] with PostgreSQL 9.1.9,the stats collector process is not
work!
Thanks for the details.
pgstat.stat file get created on the start of the server or automatically
created when not found under pg_stat_tmp
