From: Jim C. Nasby <jim@nasby.net>
To: Josh Berkus <josh@agliodbs.com>
Cc: pgsql-hackers@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [HACKERS] Hints proposal
Date: Fri, 13 Oct 2006 18:36:15 -0500
Message-ID: <20061013233615.GA381@nasby.net> (raw)
In-Reply-To: <200610131557.24420.josh@agliodbs.com>
References: <20061012151439.GT28647@nasby.net>
<200610121358.22739.josh@agliodbs.com>
<20061013161614.GT28647@nasby.net>
<200610131557.24420.josh@agliodbs.com>
On Fri, Oct 13, 2006 at 03:57:23PM -0700, Josh Berkus wrote:
> Jim,
>
> > Well, that's not what I said (my point being that until the planner and
> > stats are perfect you need a way to over-ride them)... but I've also
> > never said hints would be faster or easier than stats modification (I
> > said I hope they would).
>
> Yes, you did. Repeatedly. On this and other threads, you've made the
> statement at least three times that per-query hints are the only way to go
> for 8.3. Your insistence on this view has been so strident that if I
> didn't know you better, I would assume some kind of hidden agenda.
Let me clarify, because that's not what I meant. Right now, there's not
even a shadow of a design for anything else, and this is a tough nut to
crack. That means it doesn't appear that anything else could be done for
8.3. If I'm wrong, great. If not, we should get something in place for
users now while we come up with something better.
So, does anyone out there have a plan for how we could give user's the
ability to control the planner at a per-table level in 8.3 or even 8.4?
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: jim@nasby.net, josh@agliodbs.com, pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Hints proposal
In-Reply-To: <20061013233615.GA381@nasby.net>
* 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