Re: eliminating records not in (select id ... so SLOW?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: eliminating records not in (select id ... so SLOW?
Date: 2008-08-01 15:08:32
Message-ID: 10113.1217603312@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Huh. The only way I can see for that to happen is if the datatypes
>> involved aren't hashable. What's the datatypes of the two columns
>> being compared, anyway?

> thanks to svn I'd say you're right... one column was int the other
> bigint.

Ah. 8.3 can hash certain cross-type comparisons (including that one)
but prior versions won't.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Wilson 2008-08-01 15:31:20 Re: use of column in COPY
Previous Message Ivan Sergio Borgonovo 2008-08-01 15:04:15 Re: eliminating records not in (select id ... so SLOW?