Re: CentOS - PostgreSQL 9.2.13 -> 9.4

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: CentOS - PostgreSQL 9.2.13 -> 9.4
Дата
Msg-id 20150818180207.GJ5232@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: CentOS - PostgreSQL 9.2.13 -> 9.4  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
I wrote:

> One thing to look at is the rate of WAL generation for a set number of
> transactions.  Maybe the later releases are generating more WAL due to
> multixacts, for instance (prior to 9.3 these weren't wal-logged.)

FWIW a very easy way to measure this is to look at the output of
"pg_xlogdump -r MultiXact" for the WAL generated during the testing
period.

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: CentOS - PostgreSQL 9.2.13 -> 9.4
Следующее
От: John R Pierce
Дата:
Сообщение: Re: How to tune my new server