Postgres Pro
Downloads
Home   >   mailing lists

advice on query joining 10 tables - Mailing list pgsql-sql

From Gerardo Herzig
Subject advice on query joining 10 tables
Date
Msg-id 4BE8530C.6030605@fmed.uba.ar
Whole thread Raw
Responses Re: advice on query joining 10 tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: advice on query joining 10 tables  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-sql
Tree view 
Hi all. Im triyng to see if i can improve the performance of a query
(mainly a 10 table join)

1) Besides of triyng to use indexes, there is some rules of thumb to follow?

2) Should i try to join the bigger tables last in the query?

3) There is some place for understanding EXPLAIN better?

Thanks!
Gerardo

pgsql-sql by date:

Previous
From: Justin Graf
Date:
Subject: Re: Celko take on EAV
Next
From: Tom Lane
Date:
Subject: Re: advice on query joining 10 tables