Re: Materializing a sequential scan

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Materializing a sequential scan
Date: 2005-10-27 00:57:15
Message-ID: 20051027005715.GA11032@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-10-27 01:43:24 Re: browsing table with 2 million records
Previous Message Tom Lane 2005-10-27 00:51:03 Re: Materializing a sequential scan