Home / server / Questions / 233548
Accepted
tftd
Asked: 2011-02-10 13:13:47 +0800 CST

PostgreSQL - count() performance and how to tweak it?

  • 772

I've done some reading in google and the only thing I did was get myself confused. Some of the people say that count() is slower with many records, others say you can cache the number or even use sequence...

What's the best way to count many rows in a table with best performance and lowest cpu/ram usage? By many I mean >=500,000 rows.

postgresql performance-tuning database-performance

1 Answers

  1. Best Answer

    The best way I know of to tweak count()'s performance on huge data sets is to count() something that's been indexed (if you're trying to count a partial result, you can create a matching partial index).

    • 4