Em 28/09/2013 18:23, Jeff Janes escreveu:
On Sat, Sep 28, 2013 at 1:54 PM, Edson Richter
<edsonrich...@hotmail.com <mailto:edsonrich...@hotmail.com>> wrote:
Em 28/09/2013 15:54, Adrian Klaver escreveu:
Ok. Found the place.
So, there is nothing there. PG_DATA/base/pgsql_tmp is a empty
directory.
I've run the query over pg_stat_database view and there is nothing
wrong with pgAdmin III - the information is all there.
I've also run a vacuum freeze analyze, but made no difference.
I believe that statistics are outdated, since there is no temp
file at all.
The statistics are not current, they are cumulative since the database
was created, or pg_stat_reset() was last called.
Cheers,
Jeff
Thanks, Jeff!
I now understand.
Regards,
Edson
