From: Scott Matseas <smatseas@intrusic.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: Index usage
Date: Mon, 21 Aug 2006 16:25:10 -0400
Message-ID: <44EA16A6.6080607@intrusic.com> (raw)
In-Reply-To: <5599.1156184779@sss.pgh.pa.us>
References: <44E9EEF9.7050901@intrusic.com>
<5599.1156184779@sss.pgh.pa.us>
Tom Lane wrote:
> What other planner parameters have you been fooling with?
Hi Tom,
The other parameters that have been changed are:
set join_collapse_limit to 1
set enable_sort to off
We are using version 8.1.3. We've noticed the query plan changing depending
on the amount of data in the tables especially when the query looks at
more rows
in tableA. The parameter work_mem is set to 262,144.
Thanks,
Scott
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: smatseas@intrusic.com, tgl@sss.pgh.pa.us
Subject: Re: Index usage
In-Reply-To: <44EA16A6.6080607@intrusic.com>
* 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