Re: 60 core performance with 9.3 - Mailing list pgsql-performance

From Tomas Vondra
Subject Re: 60 core performance with 9.3
Date
Msg-id 11b808bce5fce4547fdcac5e94acb440.squirrel@sq.gransy.com
Whole thread Raw
In response to Re: 60 core performance with 9.3  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: 60 core performance with 9.3
List pgsql-performance
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



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: 60 core performance with 9.3
Next
From: Clinton Adams
Date:
Subject: Slow create temp table