Do you need left join ? Can you further normalize the tables? (to lower the I/O) Can you upgrade to at least 8.3 ? It has huuge performance improvements over 8.3. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance