| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Raúl Gutiérrez Sánchez <raul(at)laeff(dot)esa(dot)es> |
| Cc: | PgSql-SQL Mailing List <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Speed depending of Join Order. |
| Date: | 2003-01-21 15:14:32 |
| Message-ID: | 2149.1043162072@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
=?iso-8859-1?Q?Ra=FAl=20Guti=E9rrez=20S=E1nchez?= <raul(at)laeff(dot)esa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-21 15:34:41 | Re: returning setof in plpgsql |
| Previous Message | Tom Lane | 2003-01-21 15:10:20 | Re: [OT] Unsubscribe does not work |