| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_stats question |
| Date: | 2004-01-08 05:49:14 |
| Message-ID: | 3878.1073540954@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Joseph Shraibman <jks(at)selectacast(dot)net> writes:
> Tom Lane wrote:
>> As a trivial counterexample, if you have less than 100 distinct values
>> in your column, there definitely won't be 100 values in the
>> most-common-values list ...
> Right, but in this case I'm sure I have over 200 values.
Still, ANALYZE might not have seen all of them within its sample set of
rows. There's inherently some sampling error involved in the process
(at least in 7.2 and later).
I don't believe 7.4 has any significant difference from 7.3 in this
area.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2004-01-08 06:30:45 | Re: Perl and Python modules problem |
| Previous Message | Tom Lane | 2004-01-08 05:27:51 | Re: Problem with rserv replication |