Re: 60 core performance with 9.3

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 60 core performance with 9.3
Дата
Msg-id 26683.1406723992@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 60 core performance with 9.3  ("Tomas Vondra" <tv@fuzzy.cz>)
Ответы Re: 60 core performance with 9.3  ("Tomas Vondra" <tv@fuzzy.cz>)
Список 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 по дате отправления:

Предыдущее
От: Rural Hunter
Дата:
Сообщение: Re: Very slow planning performance on partition table
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: 60 core performance with 9.3