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