Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Sami DaloucheDate: 2007-10-28 21:25:10
Subject: Outer joins and Seq scans
Previous:From: Simon RiggsDate: 2007-10-28 17:27:24
Subject: Re: partitioned table and ORDER BY indexed_fieldDESCLIMIT 1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group