Re: Slow alter sequence with PG10.1 - Mailing list pgsql-general

From Rakesh Kumar
Subject Re: Slow alter sequence with PG10.1
Date
Msg-id 1611f31928f-1d2f-3419@webjas-vaa078.srv.aolmail.net
Whole thread Raw
In response to Slow alter sequence with PG10.1  (Michael Krüger <michael@kruegers.email>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Using random() in update produces same random value for all
Next
From: "David G. Johnston"
Date:
Subject: Re: Slow alter sequence with PG10.1