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-29 15:22:07
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Nimesh Satam wrote:
> Thanks for the information. join_collapse_limit = 1 is already set before
> sending the query plan.

I assume that was a typo, and you really set it to 10 or higher...

> Will a index scan on metrics.netkey help in improving the performance what
> other configuration parameters should we consider while opting for
> partition?

Whether it helps or not depends on many things, like the distribution of
the data, but it's worth trying. I'd try that first, before worrying
about config parameters.

  Heikki Linnakangas

In response to

pgsql-performance by date

Next:From: Campbell, LanceDate: 2007-10-29 16:33:57
Subject: Re: Suggestions on an update query
Previous:From: Gregory StarkDate: 2007-10-29 13:40:39
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1

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