Re: Could postgres12 support millions of sequences? (like 10 million) - Mailing list pgsql-general

From David G. Johnston
Subject Re: Could postgres12 support millions of sequences? (like 10 million)
Date
Msg-id CAKFQuwbo029fGfcsPkVhoA5Kd_c9n_2jmAbsjXHwpySKuQ3nZA@mail.gmail.com
Whole thread Raw
In response to Re: Could postgres12 support millions of sequences? (like 10 million)  (pabloa98 <pabloa98@gmail.com>)
List pgsql-general
On Friday, March 20, 2020, pabloa98 <pabloa98@gmail.com> wrote:

If there is another solution different than millions of sequences that do not block, generate few gaps (and those gaps are small) and never generate collisions then I will happily use it.

You are going to have to lose the not blocking requirement, or at least define what blocking and non-blocking interactions look like.

What does it mean that bid# 123 exists?  Can you, by way of example, just create a table of all possible bid numbers and update a null column with a timestamp saying “this bid came into existence at this moment”?

David J.

pgsql-general by date:

Previous
From: pabloa98
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)
Next
From: John W Higgins
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)