Re: pg_ctl stop -m immediate on the primary server inflates sequences

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: pg_ctl stop -m immediate on the primary server inflates sequences
Дата
Msg-id 16F3BE7D2A60E9334F1CD93C@amenophis
обсуждение исходный текст
Ответы Re: pg_ctl stop -m immediate on the primary server inflates sequences
Список pgsql-hackers

--On 10. April 2010 09:26:41 +0200 Boszormenyi Zoltan <zb@cybertec.at> 
wrote:

> The above is quite reproducable, "pg_ctl stop -m immediate"
> "usually" inflated my serial sequence, but I had two occasions
> when not. The 69 -> 70 was one. The inflated increase is always 33:

AFAIKS sequences are pre-logged with 32 values to WAL to avoid overhead. I 
suspect this is why you are seeing those gaps.

-- 
Thanks
Bernd


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

Предыдущее
От: Boszormenyi Zoltan
Дата:
Сообщение: Re: pg_ctl stop -m immediate on the primary server inflates sequences
Следующее
От: Joachim Wieland
Дата:
Сообщение: Re: a faster compression algorithm for pg_dump