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 Thu, Oct 30, 2025 at 10:42 AM Adrian Klaver <[email protected]> wrote: > 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. > > > -- > Adrian Klaver > [email protected] > > > -- Rumpi Gravenstein
