Slow PostgreSQL COUNT, a solution

Ruby
1

Hello Fellow Rubyists,

We use PostgreSQL at work and having been running into slow COUNT
queries. After a bit of research I implemented a viable workaround. I
wanted to share it and get some feed back on solutions other people have
found successful. My workaround is posted on my blog:

http://www.verygoodindicators.com/blog/2015/04/07/faster-count-queries/

Thanks,
Juan

2

What you are suggesting sounds like a complicated (hence potentially
error prone) way to access statistics data. You can query it from
system catalogs directly: