3 ms·
You're talking about index-only scans. Those appeared in Postgres 9.2, which came out about 5 years ago. INCLUDE/covering indexes are indexes that can include
by petergeoghegan 8y ago
You're talking about index-only scans. Those appeared in Postgres 9.2, which came out about 5 years ago.
INCLUDE/covering indexes are indexes that can include extra "payload" columns, and exist only for the benefit of index-only scans. You can add something extra to the primary key for the largest table in your database, all without changing how and when duplicate violation errors are raised.