If art_id is the primary key of the la table, is the latter faster? SELECT DISTINCT la.* FROM <join> ...
or SELECT DISTINCT ON (la.art_id) la.* FROM <join> ... ie. Does this offer a performance improvement by only doing the distinct on the primary key or not? Thanks, Chris ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org