From: Bruno Wolff III <bruno@wolff.to>
To: sandra ruiz <mileruiz@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: hints in Postgres?
Date: Thu, 11 Dec 2003 14:27:55 -0600
Message-ID: <20031211202755.GB9844@wolff.to> (raw)
In-Reply-To: <BAY7-F88NSB5KizJl8200026b71@hotmail.com>
References: <BAY7-F88NSB5KizJl8200026b71@hotmail.com>
On Thu, Dec 11, 2003 at 11:00:19 -0500,
sandra ruiz <mileruiz@hotmail.com> wrote:
> Hi list,
>
> I need to know if there is anything like hints of Oracle in
> Postgres..otherwise..I wish to find a way to force a query plan to use the
> indexes or tell the optimizer things like "optimize based in statistics",
> "I want to define the order of the a join" , "optimize based on a execution
> plan that I consider the best" ...
There are a few things you can do.
You can explicitly fix the join order using INNER JOIN (in 7.4 you have to set
a GUC variable for this to force join order).
You can disable specific plan types (though sequential just becomes very
expensive as sometimes there is no other way to do things).
You can set tuning values to properly express the relative cost of things
like CPU time, sequential disk reads and random disk reads.
These are done by setting GUC variables either in the postgres config
file or using SET commands. They are per backend so some queries can
be done using one set of values while others going on at the same time
use different values.
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, mileruiz@hotmail.com
Subject: Re: hints in Postgres?
In-Reply-To: <20031211202755.GB9844@wolff.to>
* 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