Re: [PERFORM] Postgres 9.1.4 - high stats collector IO usage

Sat, 28 Jul 2012 10:12:35 -0700

Thanks, Pavel.

I was a bit worried about trying this because of a comment elsewhere that the file was supposed to be permanent.  Tom's solution of increasing the vacuum delay has solved it for now.

Regards, David


On 28/07/12 15:07, Pavel Stehule wrote:
Hello

I had same problem with large numbers of tables - you can move
pg_stat_tmp to tmpfs filesystem - it was solution for us

Regards

Pavel

2012/7/28 David Barton <d...@oneit.com.au>:

Hi,

<snip>


    

    

    
-- 

      

        
      

      
 David Barton - Managing Director

        1iT Pty Ltd "The Power of One"
      

      

        Tel: (08) 9382 2296

        Direct: (08) 9200 4269

        Mob: 0404 863 671

        Fax: (08) 6210 1354

        Web: www.1it.com.au
      

      

        First Floor

        41 Oxford Close

        West Leederville, 6007
      

    

  























					Reply via email to