On 30 Červenec 2014, 14:39, Tom Lane wrote:
> "Tomas Vondra" <tv@fuzzy.cz> writes:
>> On 30 ??ervenec 2014, 3:44, Mark Kirkwood wrote:
>>> While these numbers look great in the middle range (12-96 clients),
>>> then
>>> benefit looks to be tailing off as client numbers increase. Also
>>> running
>>> with no stats (and hence no auto vacuum or analyze) is way too scary!
>
>> By disabling statistics collector you loose runtime counters - number of
>> sequential/index scans on a table, tuples read from a relation aetc. But
>> it does not influence VACUUM or planning at all.
>
> It does break autovacuum.
Of course, you're right. It throws away info about how much data was
modified and when the table was last (auto)vacuumed.
This is a clear proof that I really need to drink at least one cup of
coffee in the morning before doing anything in the morning.
Tomas