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 25226.1064360630@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:
> Neither one makes a change- perhaps something else is at work here- my
> understanding of the finer points of query plans is shaky- Here is the query
> and the plan I'm getting:

Well, one thing that's not a fine point is that if you are complaining
about poor planning, it's important to offer EXPLAIN ANALYZE output not
just EXPLAIN output ... the difference between the planner's ideas and
reality is exactly the issue ...

            regards, tom lane

pgsql-admin by date:

Previous
From: "Robert D. Abernethy IV"
Date:
Subject: Java and SSL
Next
From: Peter Eisentraut
Date:
Subject: Re: help needed!!!