On Sep 24, 2006, at 8:59 AM, Tom Lane wrote:

> Casey Duncan <casey@pandora.com> writes:
>> seed | st_id | 164656
>
>> I ran analyze after this, but the results were roughly the same.
>
> What's the statistics target set to, and did you try increasing it?
> Can we see the rest of the pg_stats row for this column (I'm mainly
> interested in the most-common-value frequencies)?

Here's the full pg_stats row:

public | seed | st_id | 0 | 8 | 138674
|
{42151109694333522,66226913946054313,1087114032961 97641,1351772151143018
06,1130147629642373,1597650524892734,1643450767611 4329,17430059620571257
,22269564345616346,28879557667799977} |
{0.001,0.001,0.001,0.001,0.000666667,0.000666667,0 .000666667,0.000666667
,0.000666667,0.000666667} |
{69337952030227,23194309459225658,4472714947428184 2,67399809385152536,93
773403960447474,116874916355760832,138282618203581 456,141866119873210938
,145491433047267294,149167246450593786,15278238485 0071963} | 0.829168

I haven't tried increasing the stats target. What would be a suitable
value to try?

Thanks

-Casey


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly