Frederik Ramm <frederik@remote.org> writes:
> The single query where pg9.0 beat pg8.3 by a country mile was a CREATE
> INDEX statement on a BIGINT column to a table with about 500 million
> records - this cost 2679 seconds on normal 8.3, 2443 seconds on
> large-memory 8.3, and aroung 1650 seconds on 9.0, large memory or not.
FWIW, that's probably due to bigint having become pass-by-value on
64-bit platforms.
regards, tom lane