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