Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Sun, 28 Oct 2007 18:22:04 +0000
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
- Follow-Ups:
- Re: Append Cost in query planners
- From: Nimesh Satam
- Re: Append Cost in query planners
- References:
- Append Cost in query planners
- From: Nimesh Satam
- Re: Append Cost in query planners
- From: Heikki Linnakangas
- Append Cost in query planners
- Prev by Date: Re: partitioned table and ORDER BY indexed_field DESCLIMIT 1
- Next by Date: Outer joins and Seq scans
- Previous by thread: Re: Append Cost in query planners
- Next by thread: Re: Append Cost in query planners
- Indexes: