On 31/07/14 00:47, Tomas Vondra wrote:
> 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.
>
Lol - thanks for taking a look anyway. Yes, coffee is often an important
part of the exercise.
Regards
Mark
