From: Tom Lane <tgl@sss.pgh.pa.us>
To: Carlo Stonebanks <stonec.register@sympatico.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: How to avoid hashjoin and mergejoin
Date: Thu, 01 Nov 2007 17:41:58 -0400
Message-ID: <15853.1193953318@sss.pgh.pa.us> (raw)
In-Reply-To: <fgdeia$763$1@news.hub.org>
References: <fgdeia$763$1@news.hub.org>
"Carlo Stonebanks" <stonec.register@sympatico.ca> writes:
> Still, the Linux server did not create the same, fast plan as the Windows
> server. In order to get the same plan we had to:
> set enable_hashjoin to 'off';
> set enable_mergejoin to 'off';
This is just about never the appropriate way to solve a performance
problem, as it will inevitably create performance problems in other
queries.
What I'm wondering is whether the tables have been ANALYZEd recently,
and also whether there are any nondefault postgresql.conf settings in
use on the other server.
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, stonec.register@sympatico.ca
Subject: Re: How to avoid hashjoin and mergejoin
In-Reply-To: <15853.1193953318@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