Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Could postgres12 support millions of sequences? (like 10 million)
Date
Msg-id CAHOFxGqsZJM5s9x3ELVtq_qRQj1odZ_L-SNKqdYyyBbd=1+_nw@mail.gmail.com
Whole thread Raw
In response to Re: Could postgres12 support millions of sequences? (like 10 million)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Could postgres12 support millions of sequences? (like 10 million)
Re: Could postgres12 support millions of sequences? (like 10 million)
List pgsql-general
Tree view


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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)
Next
From: Tom Lane
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)