From: Tom Lane <tgl@sss.pgh.pa.us>
To: Noah M. Daniels <ndaniels@mac.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Strange left outer join performance issue
Date: Fri, 23 Mar 2007 18:22:39 -0400
Message-ID: <25808.1174688559@sss.pgh.pa.us> (raw)
In-Reply-To: <797C9FCF-8C8C-4813-8979-68DF7B70FFF8@mac.com>
References: <5335C295-4D3E-4A1B-A270-6B822377DD25@mac.com>
<25685.1174688032@sss.pgh.pa.us>
<797C9FCF-8C8C-4813-8979-68DF7B70FFF8@mac.com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, ndaniels@mac.com
Subject: Re: Strange left outer join performance issue
In-Reply-To: <25808.1174688559@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox