Re: PostgreSQL 9.2.4 temp files never released?

Edson Richter <edsonrichter@xxxxxxxxxxx> · Sat, 28 Sep 2013 18:26:58 -0300



    Em 28/09/2013 18:23, Jeff Janes
      escreveu:

    
      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
          
        
    Thanks, Jeff!

    I now understand.

    
    Regards,

    
    Edson