Re: Could postgres12 support millions of sequences? (like 10 million)

On Mar 19, 2020, at 6:45 PM, pabloa98 <pabloa98@gmail.com> wrote:

On Thu, Mar 19, 2020 at 5:13 PM Adrian Klaver <adrian.klaver@aklaver.com> wrote:

On 3/19/20 3:32 PM, pabloa98 wrote:
> 
> 
> On Thu, Mar 19, 2020 at 3:17 PM Rob Sargent <robjsargent@gmail.com 
> <mailto:robjsargent@gmail.com>> wrote:I have a table called "pair":

CREATE TABLE pair(

group INT NOT NULL,

element INT NOT NULL,

CONSTRAINT PRIMARY KEY (group, element)

);

I must add entries to the table "event". This table event will have a code that will be generated using a sequence of that is a function of s(group,element). 

CREATE TABLE event(

group INT NOT NULL,

element INT NOT NULL,

code INT NOT NULL,

CONSTRAINT PRIMARY KEY(code, element, group)

);