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
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.
In response to
pgsql-performance by date
|Next:||From: Campbell, Lance||Date: 2007-10-29 16:33:57|
|Subject: Re: Suggestions on an update query|
|Previous:||From: Gregory Stark||Date: 2007-10-29 13:40:39|
|Subject: Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1|