From: Tom Lane <tgl@sss.pgh.pa.us>
To: Brian Herlihy <btherl@yahoo.com.au>
Cc: Postgresql Performance <pgsql-performance@postgresql.org>
Subject: Re: Simple join optimized badly?
Date: Tue, 10 Oct 2006 22:38:29 -0400
Message-ID: <15661.1160534309@sss.pgh.pa.us> (raw)
In-Reply-To: <20061011012202.76392.qmail@web52303.mail.yahoo.com>
References: <20061011012202.76392.qmail@web52303.mail.yahoo.com>
Brian Herlihy <btherl@yahoo.com.au> writes:
> What would it take for hints to be added to postgres?
A *whole lot* more thought and effort than has been expended on the
subject to date.
Personally I have no use for the idea of "force the planner to do
exactly X given a query of exactly Y". You don't have exactly Y
today, tomorrow, and the day after (if you do, you don't need a
hint mechanism at all, you need a mysql-style query cache).
IMHO most of the planner mistakes we see that could be fixed via
hinting are really statistical estimation errors, and so the right
level to be fixing them at is hints about how to estimate the number
of rows produced for given conditions. Mind you that's still a plenty
hard problem, but you could at least hope that a hint of that form
would be useful for more than one query.
regards, tom lane
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: tgl@sss.pgh.pa.us, btherl@yahoo.com.au
Subject: Re: Simple join optimized badly?
In-Reply-To: <15661.1160534309@sss.pgh.pa.us>
* 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