Postgres Pro
Downloads
Home   >   mailing lists

Re: Order of tables - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Order of tables
Date
Msg-id 4DB95E82.20904@enterprisedb.com
Whole thread Raw
In response to Order of tables  (Rishabh Kumar Jain <rishabh.widu@yahoo.com>)
Responses Re: Order of tables
List pgsql-performance
Tree view 
On 28.04.2011 12:20, Rishabh Kumar Jain wrote:
> How the tables must be ordered in the list of tables in from statement?

There is no difference in performance, if that's what you mean. (If not,
then pgsql-novice or pgsql-sql mailing list would've be more appropriate)

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Robert Klemme
Date:
Subject: Re: Order of tables
Next
From: Jeff Janes
Date:
Subject: Re: reducing random_page_cost from 4 to 2 to force index scan