From: Rod Taylor <rbt@rbt.ca>
To: Yusuf <yusuf0478@netscape.net>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Enabling and disabling run time configuration parameters.
Date: 05 Jun 2003 12:14:23 -0400
Message-ID: <1054829663.7579.38.camel@jester> (raw)
In-Reply-To: <3EDF633A.8000502@netscape.net>
References: <3EDF633A.8000502@netscape.net>
> My plan is for every query that could be optimized by adjusting
> parameters: I'll enable parameters that'll speed it up, run the query,
> then set the parameters back to their default values.
Unless you intend to regularly test these, or have static data this may
cause you more problems than it fixes.
Any change in the data may make the plan you have forced a non-optimal
one.
A much better approach is to tweek the cost values that cause the
planner to chose that particular plan. The random_page_cost will
probably have the most effect on the plan chosen.
#effective_cache_size = 1000 # typically 8KB each
#random_page_cost = 4 # units are one sequential page fetch
cost
#cpu_tuple_cost = 0.01 # (same)
#cpu_index_tuple_cost = 0.001 # (same)
#cpu_operator_cost = 0.0025 # (same)
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.ascAttachments:
signature.asc (application/pgp-signature, 186B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: rbt@rbt.ca, yusuf0478@netscape.net
Subject: Re: Enabling and disabling run time configuration parameters.
In-Reply-To: <1054829663.7579.38.camel@jester>
References: <3EDF633A.8000502@netscape.net> <1054829663.7579.38.camel@jester>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox