Re: [GENERAL] Increasing statistics results in worse estimates

Shelby Cain <[email protected]> Sun, 1 May 2005 20:53:33 -0700 (PDT)
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
--- Tom Lane <[email protected]> wrote:
> [ redirecting to pgsql-hackers-win32 ]
> 
> Thanks for sending me the test data.  The bad news
> is that I can't
> reproduce any strange behavior here: the stats get
> marginally more
> accurate as the target goes up, just as you'd
> expect.  So it would
> seem there is something broken about ANALYZE on
> Windows.  There's
> not anything magic about this particular dataset,
> AFAICS.
> 
> Which Windows build are you using, exactly?
> 

The installation was 8.0 which was upgraded to 8.0.2
via the official win32 installer.  I followed the
appropriate directions listed in the installer archive
for upgrading.

Regards,

Shelby Cain


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

---------------------------(end of broadcast)---------------------------
TIP 3: 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