Which Join is better - Mailing list pgsql-performance

From Adarsh Sharma
Subject Which Join is better
Date
Msg-id 4E379C43.7020805@orkash.com
Whole thread Raw
Responses Re: Which Join is better  (Szymon Guz <mabewlun@gmail.com>)
Re: Which Join is better  (Maria Arias de Reyna <marias@emergya.es>)
Re: Which Join is better  (lars hofhansl <lhofhansl@yahoo.com>)
List pgsql-performance
Dear all,

Just want to know which join is better for querying data faster.

I have 2 tables A ( 70 GB ) & B ( 7 MB )

A has 10 columns & B has 3 columns.Indexes exist on both tables's ids.

select p.* from table A p, B q where p.id=q.id

or

select p.* from table B q , A p where q.id=p.id


Thanks

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Parameters for PostgreSQL
Next
From: Szymon Guz
Date:
Subject: Re: Which Join is better