Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group