Postgresql - sequences bigger than bigint PostgreSQL sequences (CREATE SEQUENCE) are limited to bigint (which is usually big enough). But in my case I need a bigger sequence. The table will not have this much records, it will be cleaned over time, but the numbers must never be reused. As I am planning this to be used for at least 20 years, there is the need to go bigger than bigint.

I am using NUMERIC(35).

How can I achieve this with less locking as possible?

Is creating two sequences and summing them a good idea?
As pointed out by @a_horse_with_no_name, bigint is good enought. I think 29 million years is reasonable (hehe).

The math checks. Should have done it before.