Re: [GENERAL] Increasing statistics results in worse estimates

From: Shelby Cain <alyandon(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: [GENERAL] Increasing statistics results in worse estimates
Date: 2005-05-02 03:53:33
Message-ID: 20050502035333.87033.qmail@web50109.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers-win32


--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Dann Corbit 2005-05-03 21:27:56 Favorable Postgresql write up
Previous Message Tom Lane 2005-05-01 17:03:55 Re: [GENERAL] Increasing statistics results in worse estimates