Re: Simple Join - Mailing list pgsql-performance

From David Lang
Subject Re: Simple Join
Date
Msg-id Pine.LNX.4.62.0512152003460.2807@qnivq.ynat.uz
Whole thread Raw
In response to Re: Simple Join  (Mark Kirkwood <markir@paradise.net.nz>)
Responses Re: Simple Join  (Mark Kirkwood <markir@paradise.net.nz>)
List pgsql-performance
On Fri, 16 Dec 2005, Mark Kirkwood wrote:

>
> Right on. Some of these "coerced" plans may perform much better. If so, we
> can look at tweaking your runtime config: e.g.
>
> effective_cache_size
> random_page_cost
> default_statistics_target
>
> to see if said plans can be chosen "naturally".

Mark, I've seen these config options listed as tweaking targets fairly
frequently, has anyone put any thought or effort into creating a test
program that could analyse the actual system and set the defaults based on
the measured performance?

David Lang

pgsql-performance by date:

Previous
From: David Lang
Date:
Subject: Re: Overriding the optimizer
Next
From: Jaime Casanova
Date:
Subject: Re: Overriding the optimizer