Postgres Pro
Downloads
Home   >   mailing lists

Re: Forcing order of Joins etc - Mailing list pgsql-novice

From Tom Lane
Subject Re: Forcing order of Joins etc
Date
Msg-id 22336.1223037489@sss.pgh.pa.us
Whole thread Raw
In response to Re: Forcing order of Joins etc  (Steve T <steve@retsol.co.uk>)
Responses Re: Forcing order of Joins etc  (Steve T <steve@retsol.co.uk>)
Re: Forcing order of Joins etc  (Steve T <steve@retsol.co.uk>)
List pgsql-novice
Tree view 
Steve T <steve@retsol.co.uk> writes:
> So in my case, I can now see that the join_collapse_limit has indeed
> been  set back to 8 - but I'm still getting the improved query speed.

So that was in fact unrelated to your problem.  Maybe it was just that
auto-analyze caught up with changes you'd made to the table contents?

            regards, tom lane

pgsql-novice by date:

Previous
From: "Joshua Tolley"
Date:
Subject: Re: Installing postgres on Vista, can't connect remotely
Next
From: Steve T
Date:
Subject: Re: Forcing order of Joins etc