Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 20
Why is COUNT(*) on a big Postgres table slow?
A
It counts columns too
B
Postgres stores no rows
C
COUNT(*) sorts the table
D
MVCC means each transaction may see a different row count, so Postgres must scan to count visible rows