Postgres Pro
Downloads
Home   >   mailing lists

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

From John W Higgins
Subject Re: Could postgres12 support millions of sequences? (like 10 million)
Date
Msg-id CAPhAwGyWr2eGMzpafGrWr9ChFRyZ91Esz_tE7tE1HMnNCRxm9Q@mail.gmail.com
Whole thread Raw
In response to Re: Could postgres12 support millions of sequences? (like 10 million)  (pabloa98 <pabloa98@gmail.com>)
Responses Re: Could postgres12 support millions of sequences? (like 10 million)
List pgsql-general
Tree view


On Fri, Mar 20, 2020 at 8:13 PM pabloa98 <pabloa98@gmail.com> wrote:

I hope I described the problem completely.


1) What is a group - does it exist prior to records being inserted? How many groups are you working with? How long do they live for? 
2) #1 but for element
3) How many records per second per group per element are you anticipating? Are their spikes?
4) How long does a group/element live for? You can put 10 record per second over 3 years and still be under 100 million records (the size of your seq_number)
5) How quickly do you need the seq_number - if you batch created them once a minute would that work? Does it need to be quicker than that? Slower than that? Or is it an immediate need?

That's a starting point.....

John W Higgins

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)
Next
From: Adrian Klaver
Date:
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)