I've seen two indexes created on the same table/column when you create a primary key as part of table create ddl and then also run a separate create index statement for the same table/column.
On 10/30/25 01:55, Colin 't Hart wrote: > relname | relnamespace | relpersistence > --------------------------+--------------+----------------o > <sequence1> | 524799410 | p > <sequence2> | 524799410 | p > (2 rows) >
Well so much for that guess. I was exploring the idea that the sequence may have been unlogged at some point and you had both a logged(p) and unlogged(u) instance of each.
