Advice on Contiguous IDs
Hi Folks,
Looking for some help/advice - not sure if this is the appropriate channel.
My Issue:
My primary keys in a certain table are not contiguous.
What I have done so far:
I have checked the documentation and found: https://wiki.postgresql.org/wiki/FAQ#Why_are_there_gaps_in_the_numbering_of_my_sequence.2FSERIAL_column.3F_Why_aren.27t_my_sequence_nu
My Question:
1) What event would cause the CACHE clause in CREATE SEQUENCE to make an out of sequence next number?
2) In all cases am I correct in my thinking that in order to create contiguous primary key IDs then performance will greatly suffer? Do we have an idea of how bad this will generally be or what does that depend upon?
Many thanks in advance,
Brian
В списке pgsql-docs по дате отправления: