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 23:43:50
Message-ID: 25226.1064360630@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:
> 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Eisentraut 2003-09-24 00:02:32 Re: help needed!!!
Previous Message Robert D. Abernethy IV 2003-09-23 21:09:56 Java and SSL