Re: Speed depending of Join Order. - Mailing list pgsql-sql

From Tom Lane
Subject Re: Speed depending of Join Order.
Date
Msg-id 2149.1043162072@sss.pgh.pa.us
Whole thread Raw
In response to Speed depending of Join Order.  (Raúl Gutiérrez Sánchez <raul@laeff.esa.es>)
List pgsql-sql
Raúl Gutiérrez Sánchez <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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [OT] Unsubscribe does not work
Next
From: Tom Lane
Date:
Subject: Re: returning setof in plpgsql