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

From Heikki Linnakangas
Subject Re: Append Cost in query planners
Date
Msg-id 4725FA9F.7050207@enterprisedb.com
Whole thread Raw
In response to Re: Append Cost in query planners  ("Nimesh Satam" <nimesh.zedo@gmail.com>)
List 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
  EnterpriseDB   http://www.enterprisedb.com

pgsql-performance by date:

Previous
From: Gregory Stark
Date:
Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1
Next
From: "Campbell, Lance"
Date:
Subject: Re: Suggestions on an update query