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 wr
Thanks so much, Tom.
That did the job. I increased it to every 15 minutes and it has dropped
substantially even though the pgstat.stat file is over 1 MB again.
It is unfortunate that the IO utilisation of this seems to be O(n^2) as
that is a big impediment to shared hosting. Is there any ty
David Barton writes:
> I am running postgres 9.1.4 on Ubuntu 12.04 and the stats collector is
> generating very high IO usage even when nothing appears to be happening
> on the system.
> I have roughly 150 different databases, each of which is running in 1 of
> roughly 30 tablespaces. The dat
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 :
> Hi,
>
> I am running postgres 9.1.4 on Ubuntu 12.04 and the stats collector is
> generating very high IO usage even when nothing
