Postgres Pro
Downloads
Home   >   mailing lists

Re: Append Cost in query planners - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Append Cost in query planners
Date
Msg-id 4724D34C.1000606@enterprisedb.com
Whole thread Raw
In response to Append Cost in query planners  ("Nimesh Satam" <nimesh.zedo@gmail.com>)
Responses Re: Append Cost in query planners
List pgsql-performance
Tree view 
Nimesh Satam wrote:
> Following is the full plan of the query using partition. Let me know if you
> need any further information.

What indexes are there on the table partitions? You didn't post the
query, but it looks like your doing a join between rpt_network and the
partitioned table. An index on the join key might help...

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

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
Next
From: Sami Dalouche
Date:
Subject: Outer joins and Seq scans