Re: Slow alter sequence with PG10.1

From: Rakesh Kumar <rakeshkumar464(at)aol(dot)com>
To: michael(at)kruegers(dot)email, pgsql-general(at)postgresql(dot)org
Subject: Re: Slow alter sequence with PG10.1
Date: 2018-01-22 18:46:38
Message-ID: 1611f31928f-1d2f-3419@webjas-vaa078.srv.aolmail.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 faster access. The minimum value is 1 (only one value can be generated at a time, i.e., no cache), and this is also the default.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2018-01-22 18:55:55 Re: Slow alter sequence with PG10.1
Previous Message Petr Jelinek 2018-01-22 18:45:50 Re: [PATCH] Logical decoding of TRUNCATE