PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

Our first two steps aren't all that interesting; we merely create the shard schema and a sequence named table_id_seq for the IDs needed for value increments. Our design saves on implementation complexity by using the same sequence for every table within a shard, but this is not a requirement.

The bulk of the work is defined in the next_unique_id function we create. We start the function with the epoch variable, set to the beginning of 2020. This is an arbitrary starting date and could have been any date in the past. The important thing to remember is that this value is used as a baseline for how long the IDs will remain unique.

Next, we have the following section of code:

epoch_ms = floor( extract(EPOCH FROM epoch) * 1000 ...