Tom Lane wrote:
Kenneth Marshall <k...@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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
