logoalt Hacker News

whatevaayesterday at 2:30 PM0 repliesview on HN

In index oriented tables, primary keys are special. Table is organized by primary key and secondary indexes point to primary.

In postgres, primary key is basically unique index with some special semantics.