Re: Postgres 9.1.4 - high stats collector IO usage

David Barton <dave@xxxxxxxxxxxx> · Sun, 29 Jul 2012 01:11:54 +0800



    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 <dave@xxxxxxxxxxxx>:

      
        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