pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedOrder of tables
8+ messages / 3 participants
[nested] [flat]
* Order of tables
@ 2011-04-28 09:20 Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:30 ` Re: Order of tables Robert Klemme <shortcutter@googlemail.com>
2011-04-28 12:33 ` Re: Order of tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
2011-04-29 10:50 ` Re: Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
0 siblings, 3 replies; 8+ messages in thread
From: Rishabh Kumar Jain @ 2011-04-28 09:20 UTC (permalink / raw)
To: pgsql-performance
How the tables must be ordered in the list of tables in from statement?
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
@ 2011-04-28 12:30 ` Robert Klemme <shortcutter@googlemail.com>
2011-05-04 05:23 ` Re: Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-05-04 05:26 ` Re: Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-05-04 05:29 ` Re: Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2 siblings, 3 replies; 8+ messages in thread
From: Robert Klemme @ 2011-04-28 12:30 UTC (permalink / raw)
To: Rishabh Kumar Jain <rishabh.widu@yahoo.com>; +Cc: pgsql-performance
On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain <rishabh.widu@yahoo.com
> wrote:
> How the tables must be ordered in the list of tables in from statement?
>
To achieve what? Generally there is no requirement for a particular
ordering of relation names in SQL.
Cheers
robert
--
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:30 ` Re: Order of tables Robert Klemme <shortcutter@googlemail.com>
@ 2011-05-04 05:23 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2 siblings, 0 replies; 8+ messages in thread
From: Rishabh Kumar Jain @ 2011-05-04 05:23 UTC (permalink / raw)
To: pgsql-performance
Thanks for previous reply my friend.
In what manner are explicit joins added to improve performence?
Are there some rules for it?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4369082.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:30 ` Re: Order of tables Robert Klemme <shortcutter@googlemail.com>
@ 2011-05-04 05:26 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2 siblings, 0 replies; 8+ messages in thread
From: Rishabh Kumar Jain @ 2011-05-04 05:26 UTC (permalink / raw)
To: pgsql-performance
Robert Klemme-2 wrote:
>
> On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain
> <rishabh.widu@yahoo.com
> > wrote:
>
>> How the tables must be ordered in the list of tables in from statement?
>>
>
> To achieve what? Generally there is no requirement for a particular
> ordering of relation names in SQL.
>
> Cheers
>
> robert
>
> --
> remember.guy do |as, often| as.you_can - without end
> http://blog.rubybestpractices.com/
>
Ok I Understood this but there is one more problem friend
In what manner are explicit joins added to improve performence?
Are there some rules for it?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4369085.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:30 ` Re: Order of tables Robert Klemme <shortcutter@googlemail.com>
@ 2011-05-04 05:29 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2 siblings, 0 replies; 8+ messages in thread
From: Rishabh Kumar Jain @ 2011-05-04 05:29 UTC (permalink / raw)
To: pgsql-performance
Robert Klemme-2 wrote:
>
> On Thu, Apr 28, 2011 at 11:20 AM, Rishabh Kumar Jain
> <rishabh.widu@yahoo.com
> > wrote:
>
>> How the tables must be ordered in the list of tables in from statement?
>>
>
> To achieve what? Generally there is no requirement for a particular
> ordering of relation names in SQL.
>
> Cheers
>
> robert
>
>
>
Ok I Understood this but there is one more problem friend
In what manner are explicit joins added to improve performence?
Are there some rules for it?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4369091.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
@ 2011-04-28 12:33 ` Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
2011-05-04 05:30 ` Re: Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2 siblings, 1 reply; 8+ messages in thread
From: Heikki Linnakangas @ 2011-04-28 12:33 UTC (permalink / raw)
To: Rishabh Kumar Jain <rishabh.widu@yahoo.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:33 ` Re: Order of tables Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
@ 2011-05-04 05:30 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
0 siblings, 0 replies; 8+ messages in thread
From: Rishabh Kumar Jain @ 2011-05-04 05:30 UTC (permalink / raw)
To: pgsql-performance
Heikki Linnakangas-3 wrote:
>
> 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
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
I understood that now but I have one more query.
In what manner are explicit joins added to improve performence?
Are there some rules for it?
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4369093.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 8+ messages in thread
* Re: Order of tables
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
@ 2011-04-29 10:50 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2 siblings, 0 replies; 8+ messages in thread
From: Rishabh Kumar Jain @ 2011-04-29 10:50 UTC (permalink / raw)
To: pgsql-performance
On what relations are explicit joins added?
I don't know when to add explicit joins.--
View this message in context: http://postgresql.1045698.n5.nabble.com/Order-of-tables-tp4346077p4358465.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
^ permalink raw reply [nested|flat] 8+ messages in thread
end of thread, other threads:[~2011-05-04 05:30 UTC | newest]
Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-28 09:20 Order of tables Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:30 ` Robert Klemme <shortcutter@googlemail.com>
2011-05-04 05:23 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-05-04 05:26 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-05-04 05:29 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-28 12:33 ` Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
2011-05-04 05:30 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
2011-04-29 10:50 ` Rishabh Kumar Jain <rishabh.widu@yahoo.com>
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