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

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Could postgres12 support millions of sequences? (like 10 million)
Date: 2020-03-21 20:51:35
Message-ID: 4830DEFF-4229-4F28-9FFB-AF8186E42CD4@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Mar 21, 2020, at 1:13 PM, Peter J. Holzer <hjp-pgsql(at)hjp(dot)at> wrote:
>
> On 2020-03-21 12:55:33 -0600, Rob Sargent wrote:
>> To me the description of the ID smacks of database-in-the-name folly. I
>> recognize that OP is likely unable to take another path. I’ll not push this any
>> further.
>
> Identifiers often have internal structure. In Austria for example, the
> social security number contains the birth date. Invoice numbers, project
> numbers or court case numbers often contain the year.
>
> That's because they are used by *people*, and people like their
> identifiers to make some kind of sense. The computer doesn't care.

Since OP said this was digital not paper, I see this as a presentation problem bleeding into database design (assuming your response was an invitation to push further).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alastair McKinley 2020-03-21 21:16:24 Re: Explain says 8 workers planned, only 1 executed
Previous Message Jeremy Smith 2020-03-21 20:50:15 Re: Explain says 8 workers planned, only 1 executed