Tim Uckun <timuc...@gmail.com> writes:
> relname | pg_relation_size | reltuples | relpages
> ------------------------+------------------+-------------+----------
> consolidated_urls | 1303060480 | 1.80192e+06 | 159065
> consolidated_urls_pkey | 114745344 | 1.80192e+06 | 14007
With a table that large, you're probably going to need a larger stats
target in order to get reasonable estimates for low-frequency values.
Am I right in guessing that pg_stats.n_distinct is much too low for
the domain_id column?
regards, tom lane
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
