Re: Strange left outer join performance issue - Mailing list pgsql-performance

From Tom Lane
Subject Re: Strange left outer join performance issue
Date
Msg-id 25808.1174688559@sss.pgh.pa.us
Whole thread Raw
In response to Re: Strange left outer join performance issue  ("Noah M. Daniels" <ndaniels@mac.com>)
List pgsql-performance
"Noah M. Daniels" <ndaniels@mac.com> writes:
> You're right; this is postgres 8.0.8. Perhaps upgrading will solve
> this issue. Is there any way to get this query to perform better in
> postgres 8.0.8?

You could try reducing random_page_cost, but I'm not sure that will
help much.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Noah M. Daniels"
Date:
Subject: Re: Strange left outer join performance issue
Next
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] EXISTS optimization