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

From Rob Sargent
Subject Re: Could postgres12 support millions of sequences? (like 10 million)
Date
Msg-id 796417DB-2DCB-4667-99B5-A8919358792E@gmail.com
Whole thread Raw
In response to Re: Could postgres12 support millions of sequences? (like 10 million)  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general

> On Mar 20, 2020, at 5:29 PM, Peter J. Holzer <hjp-pgsql@hjp.at> wrote:
>
> 
>>
>>
>> OP  has said small gaps are ok.
>
> Yes. This wasn't a response to the OP's requirements, but to David's
> (rather knee-jerk, IMHO) "don't use sequences" response. Very often the
> requirements which would preclude sequences also preclude any other
> solution.
>
> (In the case of the OP's problem, I'd agree that sequences are probably
> a bad idea for the reasons he anticipates)
>
>> To me that says the requirement
>
> Which requirement? The OP's or the one I posed here?
>
>> is capricious but we haven’t heard the rationale for the requirement
>> yet (or I missed it)
>
> The OP gave a rationale: He has to fit the counter into an 8-digit
> field, and a global counter would overflow that. So he needs per-element
> counters.
>
>        hp

Isn’t that the implementation of a req along the lines of “we want to number the occurrences of these pairs because
...”?
>
> --
>   _  | Peter J. Holzer    | Story must make more sense than reality.
> |_|_) |                    |
> | |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
> __/   | http://www.hjp.at/ |       challenge!"



pgsql-general by date:

Previous
From: "Peter J. Holzer"
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)