Re: Union test case broken in make check?

Emmanuel Cecchet <manu@asterdata.com>

From: Emmanuel Cecchet <manu@asterdata.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Kenneth Marshall <ktm@rice.edu>, Emmanuel Cecchet <Emmanuel.Cecchet@asterdata.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2009-11-20T14:47:39Z
Lists: pgsql-hackers
Tom Lane wrote:
> Kenneth Marshall <ktm@rice.edu> writes:
>   
>> Without an order by, the order is not defined.
>>     
>
> Yeah, but with the same data and the same software it should generally
> give the same result; as evidenced by the fact that these same
> regression tests have worked for most people for years.  There's
> something odd happening on Emmanuel's machine.  Maybe he's changed
> the hashing algorithms or some planner cost parameters?
>   
I did not change anything to Postgres and I can reproduce the problem 
with a vanilla checkout of HEAD. However, I think I started to see the 
problem since my last VMWare and OS upgrade (unfortunately I did both 
simultaneously).

For info, I am using VMWare Workstation v6.5.3 build-185404 on Vista 
6.0.60002 SP2. The VM is an Ubuntu 9.04 (Jaunty) with a 2.6.28-16 SMP 
kernel on x86_64 (2 cores available for the VM, 4 cores total). gcc is 
4.3.3 (Ubuntu 4.3.3-5ubuntu4).

Let me know if you need additional info about my setup.

Emmanuel

-- 
Emmanuel Cecchet
Aster Data
Web: http://www.asterdata.com