From: David Barton <dave@oneit.com.au>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
Date: Sun, 29 Jul 2012 01:11:54 +0800
Message-ID: <50141D5A.2090302@oneit.com.au> (raw)
In-Reply-To: <CAFj8pRB=Tq-xYeMHSE=52Oqkpx=miazcqEgwHa+m3cFxTo7i2g@mail.gmail.com>
References: <50136B8D.7070502@oneit.com.au>
<CAFj8pRB=Tq-xYeMHSE=52Oqkpx=miazcqEgwHa+m3cFxTo7i2g@mail.gmail.com>
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@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
Attachments:Logo.gif (image/gif, 4.9K) downloadview image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dave@oneit.com.au, pavel.stehule@gmail.com
Subject: Re: Postgres 9.1.4 - high stats collector IO usage
In-Reply-To: <50141D5A.2090302@oneit.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox