Re: Problem with n_distinct being consistently inaccurate.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nickf(at)ontko(dot)com
Cc: "pgsql-admin" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem with n_distinct being consistently inaccurate.
Date: 2003-09-23 20:07:33
Message-ID: 22043.1064347653@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Nick Fankhauser" <nickf(at)ontko(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mark Carew 2003-09-23 20:20:52 Re: steps to ensure referential integrity
Previous Message Nick Fankhauser 2003-09-23 20:03:57 Re: Problem with n_distinct being consistently inaccurate.