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

From Tom Lane
Subject Re: 60 core performance with 9.3
Date
Msg-id 26683.1406723992@sss.pgh.pa.us
Whole thread Raw
In response to Re: 60 core performance with 9.3  ("Tomas Vondra" <tv@fuzzy.cz>)
Responses Re: 60 core performance with 9.3  ("Tomas Vondra" <tv@fuzzy.cz>)
List pgsql-performance
"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.

            regards, tom lane


pgsql-performance by date:

Previous
From: Rural Hunter
Date:
Subject: Re: Very slow planning performance on partition table
Next
From: "Tomas Vondra"
Date:
Subject: Re: 60 core performance with 9.3