Postgres Pro
Downloads
Home   >   mailing lists

Re: join optimization problem - Mailing list pgsql-sql

From Tom Lane
Subject Re: join optimization problem
Date
Msg-id 2180.1059698182@sss.pgh.pa.us
Whole thread Raw
In response to join optimization problem  (Toby Tremayne <toby@lyricist.com.au>)
Responses Re: join optimization problem  (Toby Tremayne <toby@lyricist.com.au>)
List pgsql-sql
Tree view 
Toby Tremayne <toby@lyricist.com.au> writes:
> the explain data I'm currently getting is this:

"explain analyze" would be much more useful.

Also, I assume you've vacuum analyzed these tables recently?
        regards, tom lane

pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Does a the block of code within a stored procedure constitute
Next
From: Rod Taylor
Date:
Subject: Re: join optimization problem