How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL | Lobsters

5

How partial, covering, and multicolumn indexes may slow down UPDATEs in PostgreSQL databases performance postgres.ai
via sjamaan 18 days ago | cached | 1 comment

1

2

sjamaan edited 18 days ago | link

I learned some of the nuances of using covering indexes, which I’d never used before, and learned about the existence of pgbench.