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