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