Re: Problem with n_distinct being consistently inaccurate. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Problem with n_distinct being consistently inaccurate.
Date
Msg-id 22043.1064347653@sss.pgh.pa.us
Whole thread Raw
In response to Re: Problem with n_distinct being consistently inaccurate.  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: Problem with n_distinct being consistently inaccurate.  ("Nick Fankhauser" <nickf@ontko.com>)
List pgsql-admin
"Nick Fankhauser" <nickf@ontko.com> writes:
> when I do a \d on pg_stats, it appears that pg_statistic.starelid matches up
> with pg_class.oid, but apparently this is not the case.

It certainly should be the case.  starelid matches to pg_class.oid and
staattnum matches to pg_attribute.attnum.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: Re: Problem with n_distinct being consistently inaccurate.
Next
From: "scott.marlowe"
Date:
Subject: Re: help needed!!!