Re: join optimization problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: toby(at)lyricist(dot)com(dot)au
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: join optimization problem
Date: 2003-08-01 00:36:22
Message-ID: 2180.1059698182@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Toby Tremayne <toby(at)lyricist(dot)com(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2003-08-01 00:37:18 Re: Does a the block of code within a stored procedure constitute
Previous Message Rod Taylor 2003-08-01 00:33:23 Re: join optimization problem