Could you provide the output of EXPLAIN ANALYZE with your query? On Fri, Jan 9, 2009 at 7:06 PM, Reg Me Please <regmeple...@gmail.com> wrote: > Hi. > > For an INNER JOINed query, EXPLAIN says that a "nested loop" is responsible > for the big part of the time needed to run. > > The 2 tables JOINed are: > > T1: multi-million rows > T2: few dozens rows > > The join is though a single column in both sides and it's NOT a PK in either > table. But I have indexes in both T1 and T2 for that column. > > I've read in the "Explaining EXPLAIN" by Rober Treat > (at http://wiki.postgresql.org/wiki/Image:OSCON2005-ExplainingExplain.sxi) > that this nested loop can be slow because of lacking of indexes. > > Is there any hint to try to speed that query up? > > As of now, only a REINDEX can help thanks to caching, I presume. > But the EXPLAIN still says there's a slow nested loop. > > -- > Fahrbahn ist ein graues Band > weisse Streifen, grüner Rand > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
