Postgres Pro
Downloads
Home   >   mailing lists

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 22374.1064349244@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
Tree view 
"Nick Fankhauser" <nickf@ontko.com> writes:
> So... I updated stadistinct to the actual value of 92,000 as you suggested
> and as you predicted, it did not change the plan a bit.

Just out of curiosity, what happens if you make it bigger than 92k?
Does a value 10x or 100x reality change the plan?

            regards, tom lane

pgsql-admin by date:

Previous
From: "Mark Carew"
Date:
Subject: Re: steps to ensure referential integrity
Next
From: "Nick Fankhauser"
Date:
Subject: Re: Problem with n_distinct being consistently inaccurate.