Date: Thu, 27 Oct 2005 02:13:48 +0200
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: Materializing a sequential scan
Message-ID: <20051027001348.GA7756@uio.no>
Mail-Followup-To: pgsql-performance@postgresql.org
References: <20051019174544.GA32303@samfundet.no>
	<20051026213730.GA2295@uio.no> <12333.1130367975@sss.pgh.pa.us>
	<20051026232219.GA6390@uio.no> <12708.1130370782@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <12708.1130370782@sss.pgh.pa.us>
User-Agent: Mutt/1.5.11

On Wed, Oct 26, 2005 at 07:53:02PM -0400, Tom Lane wrote:
> I don't think you're getting a correct reading for optup, but OID
> 2373 is timestamp = date:
>
> [...]
> 
> My recollection is that there was no such operator in 7.4; probably in
> 7.4 the IN ended up using timestamp = timestamp which is hashable.

You are quite correct, there is no such operator (whether by oid or by
description) in my 7.4 installation.

> What's not clear though is why you're getting that operator --- aren't
> both sides of the IN of type "date"?

Aha!

Figured out the "start" column wasn't the problem after all. The problem was
the "stopp" column, which was timestamp on one side and date on the other...

So, it can be fixed for this instance, but this feels a bit like the pre-8.0
joins on differing data types -- is there any way to fix it? :-)

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