Postgres MVCC
Indexes
Indexes have a few problems in Postgres, due to the MVCC implementation.
Schema
create table T(id int not null primary key,
a int);
There is a unique index on T(id) because id is the primary key.
Postgres MVCCIndexesIndexes have a few problems in Postgres, due to the MVCC implementation. Schema
create table T(id int not null primary key,
a int);
There is a unique index on T(id) because id is the primary key.
|