Re: optimalisation with EXCEPT clause - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: optimalisation with EXCEPT clause
Date
Msg-id j2m2f4958ff1004130823pa7b17227ld106923e0c4d6fc4@mail.gmail.com
Whole thread Raw
In response to optimalisation with EXCEPT clause  ("Kincel, Martin" <MKincel@soitron.com>)
Responses Re: optimalisation with EXCEPT clause  ("Kincel, Martin" <MKincel@soitron.com>)
List 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

pgsql-general by date:

Previous
From: "Kincel, Martin"
Date:
Subject: optimalisation with EXCEPT clause
Next
From:
Date:
Subject: Re: General question about speed of functions