Seems like there is an issue with reltuples showing twice the number of rows

2018-04-03 Thread Ranjith Ramachandra
I am relying on reltuples on my web app to get fast row counts. This was recommended by this article to get fast approx row counts: https://wiki.postgresql.org/wiki/Count_estimate However for some table I am getting twice as many values when I try to do this. I did some more research and came up

Re: Seems like there is an issue with reltuples showing twice the number of rows

2018-04-03 Thread Ranjith Ramachandra
/151956654251.6915.675951950408204404.p...@coridan.postgresql.org On Tue 3 Apr, 2018, 19:49 Tom Lane, wrote: > Tomas Vondra writes: > > On 04/03/2018 11:14 AM, Ranjith Ramachandra wrote: > >> it returns > >> reltuples | n_live_tup | n_dead_tup > >> -++-