Re: statement stats extra load?

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

 



On 21 sep 2009, at 23.41, Bruce Momjian <bruce@xxxxxxxxxx> wrote:

Alan McKay wrote:
And if so, where does that extra load go? ? ?Disk? ?CPU? ?RAM?

As of 8.4.X the load isn't measurable.

Thanks Bruce. What about 8.3 since that is our current production DB?

Same.  All statsistics settings that are enabled by default have
near-zero overhead.  Is there a specific setting you are thinking of?

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.

8.4 makes this *a lot* better with two new features. One enabled by default (write stats file on demand) and one you have to enable manually (stats file location). Using both these together can pretty much get rid of the issue, but there's no way in 8.3.

/Magnus


--
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