Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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 

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group