After upgrade from 9.2.9 to 9.3.5 got reduced contention

Поиск
Список
Период
Сортировка
Искать
От
Edson Carlos Ericksson Richter
Тема
After upgrade from 9.2.9 to 9.3.5 got reduced contention
Дата
Msg-id
BLU436-SMTP5896B9026772B9138E7349CFCA0@phx.gbl
Список
Дерево обсуждения
After upgrade from 9.2.9 to 9.3.5 got reduced contention Edson Carlos Ericksson Richter <edsonrichter@hotmail.com>
Re: After upgrade from 9.2.9 to 9.3.5 got reduced contention Bruce Momjian <bruce@momjian.us>
After a week or so since upgrade from 9.2.9 to 9.3.5 I'm very surprised 
(in a good way) by the gain of performance.

Most noticeable change is the reduced contention for records by 
exclusive/shared locks.

I can see increased numbers of requests fulfilled per minute (but I 
can't be exact on those numbers, just I can see graph going high - which 
is good).

Also, I've noticed that backup time dropped from 44 minutes to 30 
minutes (for about 60Gb in multiple databases) - which is really good 
change (35% decrease) on same hardware.

I still had no time to measure how much gain on improved indexing and 
other topics I know received improvements.


Thanks, PostgreSQL team!

Regards,

Edson


В списке pgsql-general по дате отправления
От: Edson Carlos Ericksson Richter
Дата:
От: Bruce Momjian
Дата:
FAQ