pgsql: When updating reltuples after ANALYZE, just extrapolate from our

2018-03-13 Thread Tom Lane
When updating reltuples after ANALYZE, just extrapolate from our sample. The existing logic for updating pg_class.reltuples trusted the sampling results only for the pages ANALYZE actually visited, preferring to believe the previous tuple density estimate for all the unvisited pages. While

pgsql: When updating reltuples after ANALYZE, just extrapolate from our

2018-03-13 Thread Tom Lane
When updating reltuples after ANALYZE, just extrapolate from our sample. The existing logic for updating pg_class.reltuples trusted the sampling results only for the pages ANALYZE actually visited, preferring to believe the previous tuple density estimate for all the unvisited pages. While

pgsql: When updating reltuples after ANALYZE, just extrapolate from our

2018-03-13 Thread Tom Lane
When updating reltuples after ANALYZE, just extrapolate from our sample. The existing logic for updating pg_class.reltuples trusted the sampling results only for the pages ANALYZE actually visited, preferring to believe the previous tuple density estimate for all the unvisited pages. While

pgsql: When updating reltuples after ANALYZE, just extrapolate from our

2018-03-13 Thread Tom Lane
When updating reltuples after ANALYZE, just extrapolate from our sample. The existing logic for updating pg_class.reltuples trusted the sampling results only for the pages ANALYZE actually visited, preferring to believe the previous tuple density estimate for all the unvisited pages. While

pgsql: When updating reltuples after ANALYZE, just extrapolate from our

2018-03-13 Thread Tom Lane
When updating reltuples after ANALYZE, just extrapolate from our sample. The existing logic for updating pg_class.reltuples trusted the sampling results only for the pages ANALYZE actually visited, preferring to believe the previous tuple density estimate for all the unvisited pages. While

pgsql: When updating reltuples after ANALYZE, just extrapolate from our

2018-03-13 Thread Tom Lane
When updating reltuples after ANALYZE, just extrapolate from our sample. The existing logic for updating pg_class.reltuples trusted the sampling results only for the pages ANALYZE actually visited, preferring to believe the previous tuple density estimate for all the unvisited pages. While