Thread: Re: [GENERAL] Increasing statistics results in worse estimates

Re: [GENERAL] Increasing statistics results in worse estimates

From
Shelby Cain
Date:
--- Tom Lane <tgl@sss.pgh.pa.us> 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