Re: Materializing a sequential scan - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Materializing a sequential scan
Date
Msg-id 20051027005715.GA11032@uio.no
Whole thread Raw
In response to Re: Materializing a sequential scan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Wed, Oct 26, 2005 at 08:51:03PM -0400, Tom Lane wrote:
> I have some ideas in the back of my head about supporting
> cross-data-type hashing.  Essentially this would require that the hash
> functions for two types be compatible in that they generate the same
> hash value for two values that would be considered equal.

OK, another entry for the TODO then.

Anyhow, my query is now on about the same performance level with 8.1 as it
was with 7.4 (or rather, a bit faster), so it's no longer a 8.1 blocker for
us. Thanks. :-)

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Materializing a sequential scan
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: browsing table with 2 million records