Small PostgreSQL performance tricks

Do not use SELECT DISTINCT – use GROUP BY From my experiences with PG 8.4 and PG 9.3 I can say that this is true. So far GROUP BY was always quicker or even much more quick. select distinct column from table select column from table group by column   use...