Gurjeet Singh <singh.gurjeet@xxxxxxxxx> wrote: > how many rows does "bbb" have? And what are the data types of > column aaa.idand bbb.topic_id? For that matter, is there a unique index (directly or as the result of a constraint) on the aaa.id column (by itself)? -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance