Re: Slow alter sequence with PG10.1

Поиск
Список
Период
Сортировка
От Rakesh Kumar
Тема Re: Slow alter sequence with PG10.1
Дата
Msg-id 1611f31928f-1d2f-3419@webjas-vaa078.srv.aolmail.net
обсуждение исходный текст
Ответ на Slow alter sequence with PG10.1  (Michael Krüger <michael@kruegers.email>)
Список pgsql-general
why are you not using CACHE clause which is precisely for the purpose :

cache
The optional clause CACHE cache specifies how many sequence numbers are to be preallocated and stored in memory for
fasteraccess. The minimum value is 1 (only one value can be generated at a time, i.e., no cache), and this is also the
default.


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