Re: 60 core performance with 9.3

Поиск
Список
Период
Сортировка
От Mark Kirkwood
Тема Re: 60 core performance with 9.3
Дата
Msg-id 53D981EC.40504@catalyst.net.nz
обсуждение исходный текст
Ответ на Re: 60 core performance with 9.3  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-performance
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



В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: 60 core performance with 9.3
Следующее
От: Matt Clarkson
Дата:
Сообщение: Re: 60 core performance with 9.3