Re: Simple Join

From: David Lang <dlang(at)invendra(dot)net>
To: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
Cc: Mitch Skinner <lists(at)arctur(dot)us>, Kevin Brown <blargity(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Simple Join
Date: 2005-12-16 04:05:29
Message-ID: Pine.LNX.4.62.0512152003460.2807@qnivq.ynat.uz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message David Lang 2005-12-16 04:22:58 Re: Overriding the optimizer
Previous Message David Lang 2005-12-16 04:02:58 Re: Overriding the optimizer