Hi Kai,
You are right, postgresql Count() function is slow, because; It's
physically count the rows one by one.
Other database systems using indexes for counting, but postgresql walk
through all rows in multiple transactions with different row states for
calculating the real row count. This is
Kai Sellgren kaisellgren 'at' gmail.com writes:
Hi,
I'm experiecing slow count performance:
SELECT COUNT(*) AS count
FROM NewsArticle
Takes 210 ms. I've run analyze and vacuum. I'm on 9.3. Here're the stats
http:/
/d.pr/i/6YoB
I don't understand why is it that slow. It returns 1
Hi,
I'm experiecing slow count performance:
SELECT COUNT(*) AS count
FROM NewsArticle
Takes 210 ms. I've run analyze and vacuum. I'm on 9.3. Here're the stats
http://d.pr/i/6YoB
I don't understand why is it that slow. It returns 1 integer, and counts
without filters.
This performs quickly: