On Sep 24, 2006, at 8:59 AM, Tom Lane wrote:
Casey Duncan <[EMAIL PROTECTED]> 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,108711403296197641,1351772151143018
06,1130147629642373,1597650524892734,16434507676114329,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,44727149474281842,67399809385152536,93
773403960447474,116874916355760832,138282618203581456,141866119873210938
,145491433047267294,149167246450593786,152782384850071963} | 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 [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
