Re: Append Cost in query planners

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, nimesh(at)zedo(dot)com
Subject: Re: Append Cost in query planners
Date: 2007-10-28 18:22:04
Message-ID: 4724D34C.1000606@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Sami Dalouche 2007-10-28 21:25:10 Outer joins and Seq scans
Previous Message Simon Riggs 2007-10-28 17:27:24 Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1