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).
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 |