Jon Nelson <jnelson+pgsql@xxxxxxxxxxx> wrote: > What is the difference between a plain join and a semi join? As soon as a semi join finds a match it stops looking for more. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance