From: Josh Berkus <josh@agliodbs.com>
To: Csaba Nagy <nagy@ecircle-ag.com>
Cc: postgres hackers <pgsql-hackers@postgresql.org>
Cc: Jim C. Nasby <jim@nasby.net>
Cc: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: [HACKERS] Hints proposal
Date: Thu, 12 Oct 2006 09:45:23 -0700
Message-ID: <452E7123.1090302@agliodbs.com> (raw)
In-Reply-To: <1160670865.28751.58.camel@coppola.muc.ecircle.de>
References: <20061012151439.GT28647@nasby.net>
<10866.1160667752@sss.pgh.pa.us>
<1160670865.28751.58.camel@coppola.muc.ecircle.de>
Csaba,
> I guess the angle is: I, as a practicing DBA would like to be able to
> experiment and get most out of the imperfect tool I have, and you, the
> developers, want to make the tool perfect... I don't care about perfect
> tools, it just have to do the job... hints or anything else, if I can
> make it work GOOD ENOUGH, it's all fine. And hints is something I would
> understand and be able to use.
Hmmm, if you already understand Visual Basic syntax, should we support
that too? Or maybe we should support MySQL's use of '0000-00-00' as the
"zero" date because people "understand" that?
We're just not going to adopt a bad design because Oracle DBAs are used
to it. If we wanted to do that, we could shut down the project and
join a proprietary DB staff.
The current discussion is:
a) Planner tweaking is sometimes necessary;
b) Oracle HINTS are a bad design for planner tweaking;
c) Can we come up with a good design for planner tweaking?
So, how about suggestions for a good design?
--Josh Berkus
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: josh@agliodbs.com, nagy@ecircle-ag.com, pgsql-hackers@postgresql.org, jim@nasby.net
Subject: Re: [HACKERS] Hints proposal
In-Reply-To: <452E7123.1090302@agliodbs.com>
* 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