Search Postgresql Archives

Re: PostgreSQL 9.2.4 temp files never released?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Sat, Sep 28, 2013 at 1:54 PM, Edson Richter <edsonrichter@xxxxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux