Re: Postgres 9.1.4 - high stats collector IO usage

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(at)oneit(dot)com(dot)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