From: Tom Lane <tgl@sss.pgh.pa.us>
To: Raúl Gutiérrez Sánchez <raul@laeff.esa.es>
Cc: PgSql-SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: Speed depending of Join Order.
Date: Tue, 21 Jan 2003 10:14:32 -0500
Message-ID: <2149.1043162072@sss.pgh.pa.us> (raw)
In-Reply-To: <3E2D3467.BEA05FE9@laeff.esa.es>
References: <3E2D3467.BEA05FE9@laeff.esa.es>
=?iso-8859-1?Q?Ra=FAl=20Guti=E9rrez=20S=E1nchez?= <raul@laeff.esa.es> writes:
> Note that the only difference is the order of the join elements. Using
> version 7.2.2, which I have been using untill now, the time expended in
> both of them was the same, using the right indexes. However, using
> version 7.3.1 which I have instaled recently, the results of the explain
> are the following:
That seems like a bug. Are the tables small enough that you could send
me a pg_dump of them? I doubt I can reproduce this without the specific
test case.
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-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, raul@laeff.esa.es
Subject: Re: Speed depending of Join Order.
In-Reply-To: <2149.1043162072@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