Re: optimalisation with EXCEPT clause

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: "Kincel, Martin" <MKincel(at)soitron(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: optimalisation with EXCEPT clause
Date: 2010-04-13 15:23:35
Message-ID: j2m2f4958ff1004130823pa7b17227ld106923e0c4d6fc4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

if you have a primary key on the table, and you should, you might get better
performance using LEFT JOIN.
EXCEPT will compare all columns, which might not be that fast, especially if
those are text. (hence why I always tell others to use int as key in a
table, but that's a different story).

--
GJ

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tv 2010-04-13 15:37:03 Re: General question about speed of functions
Previous Message Kincel, Martin 2010-04-13 15:01:18 optimalisation with EXCEPT clause