-Original Message-
From: Tomas Vondra [mailto:t...@fuzzy.cz]
Sent: Friday, June 20, 2014 8:14 PM
To: Pavel Stehule
Cc: Huang, Suya; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] huge pgstat.stat file on PostgreSQL 8.3.24
On 20 Červen 2014, 5:33, Pavel Stehule wrote:
2014-06
On 20 Červen 2014, 5:33, Pavel Stehule wrote:
2014-06-20 1:44 GMT+02:00 Huang, Suya suya.hu...@au.experian.com:
Thanks Pavel, to be more clear, what does pg_stat_reset really reset?
In the document it says Reset all statistics counters for the current
database to zero(requires superuser
On 19 Červen 2014, 7:35, Huang, Suya wrote:
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Thursday, June 19, 2014 3:28 PM
To: Huang, Suya
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] huge pgstat.stat file on PostgreSQL 8.3.24
Hello
The size of statfile
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Thursday, June 19, 2014 3:41 PM
To: Huang, Suya
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19 7:35 GMT+02:00 Huang, Suya suya.hu...@au.experian.com:
From: Pavel
2014-06-20 1:44 GMT+02:00 Huang, Suya suya.hu...@au.experian.com:
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Thursday, June 19, 2014 3:41 PM
To: Huang, Suya
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] huge pgstat.stat file on PostgreSQL 8.3.24
2014-06-19
Hello
The size of statfile is related to size of database objects in database.
Depends on PostgreSQL version this file can be one per database cluster or
one per database (from 9.3),
These statistics should by reset by call pg_stat_reset()
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Thursday, June 19, 2014 3:28 PM
To: Huang, Suya
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] huge pgstat.stat file on PostgreSQL 8.3.24
Hello
The size of statfile is related to size of database objects in database
2014-06-19 7:35 GMT+02:00 Huang, Suya suya.hu...@au.experian.com:
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Thursday, June 19, 2014 3:28 PM
To: Huang, Suya
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] huge pgstat.stat file on PostgreSQL 8.3.24
Hello