On 4/9/19 9:45 AM, Sherrylyn Branchaw wrote:
> If a table has 1.8M rows in reality, yet pg_stat_get_live_tuples()
> returns 1.8K, does it matter to the performance of the database, as long
> as pg_class.reltuples is the right order of magnitude?
What version of Postgres?
How are you getting at the 1.8M number?
>
> The query planner seems to use the accurate estimate, but what about the
> autovacuum daemon? Or anything else?
>
> In short, is pg_stat_get_live_tuples() (and the views that invoke it)
> used by any built-in tooling, or is it just there for the user to do
> monitoring?
>
> Thanks,
> Sherrylyn
--
Adrian Klaver
adrian.klaver@aklaver.com