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
/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
> >> -++-