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

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Could postgres12 support millions of sequences? (like 10 million)
Дата
Msg-id CAHOFxGqsZJM5s9x3ELVtq_qRQj1odZ_L-SNKqdYyyBbd=1+_nw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Could postgres12 support millions of sequences? (like 10 million)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Could postgres12 support millions of sequences? (like 10 million)
Re: Could postgres12 support millions of sequences? (like 10 million)
Список pgsql-general
Дерево обсуждения


On Thu, Mar 19, 2020, 5:48 PM David G. Johnston <david.g.johnston@gmail.com> wrote:
However, one other consideration with sequences: do you care that PostgreSQL will cache/pin (i.e., no release) every single sequence you touch for the lifetime of the session? (I do not think DISCARD matters here but I'm just guessing)


Would you expand on this point or is there someplace specific in the documentation on this?

В списке pgsql-general по дате отправления:

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