Re: statement stats extra load?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Sep 22, 2009 at 2:42 AM, Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:
> That's not true at all.
>
> If you have many relations in your cluster that have at some point been
> touched, the starts collector can create a *significant* load on the I/o
> system. I've come across several cases where the only choice was to disable
> the collector completely, even given all the drawbacks from that.

Thanks Magnus, I thought that other response sounded a bit fanciful :-)

So is there any way to predict the load this will have?   Or just try
it and hope for the best?  :-)

Right now on our 8.3 system it is off and we'd like to turn it on


-- 
“Don't eat anything you've ever seen advertised on TV”
         - Michael Pollan, author of "In Defense of Food"

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux