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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Could postgres12 support millions of sequences? (like 10 million)
Дата
Msg-id CAKFQuwbo029fGfcsPkVhoA5Kd_c9n_2jmAbsjXHwpySKuQ3nZA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Could postgres12 support millions of sequences? (like 10 million)  (pabloa98 <pabloa98@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: pabloa98
Дата:
Сообщение: Re: Could postgres12 support millions of sequences? (like 10 million)
Следующее
От: John W Higgins
Дата:
Сообщение: Re: Could postgres12 support millions of sequences? (like 10 million)