There are many reasons for not using a bigserial index, such as avoiding the data leak associated with publicly visible sequential database indexes. These reaso

There are many reasons for not using a bigserial index, such as avoiding the data leak associated with publicly visible sequential database indexes. These reasons apply regardless of where an index is generated. Generating IDs away from the database is mainly done due to design restrictions demanding it, not because it is beneficial.