From: | "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Hints proposal |
Date: | 2006-10-16 00:25:31 |
Message-ID: | 4532D17B.20106@modgraph-usa.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
So let's cut to the bone: If someone thinks a proposal is a bad idea, and they're volunteering their time on an open-source project, why would they implement the proposal?
In all the heat and smoke, I believe there are two basic conclusions we all agree on.
1. Optimizer:
a) A perfect optimizer would be a wonderful thing
b) Optimization is a hard problem
c) Any problem that can be solve by improving the optimizer *should*
be solved by improving the optimizer.
2. Hints
a) On a aesthetic/theoretical level, hints suck. They're ugly and rude
b) On a practical level, introducing hints will cause short- and long-term problems
c) Hints would help DBAs solve urgent problems for which there is no other solution
The disagreements revolve around the degree to which 1 conflicts with 2.
1. Developers feel very strongly about 2(a) and 2(b).
2. DBAs "in the trenches" feel very strongly about 2(c).
So my question is: Is there any argument that can be made to persuade those of you who are volunteering your time on the optimizer to even consider a HINTS proposal? Has all this discussion changed your perspective on 2(c), and why it really matters to some of us? Are we just wasting our time, or is this a fruitful discussion?
Thanks,
Craig
From | Date | Subject | |
---|---|---|---|
Next Message | Jeremy Drake | 2006-10-16 01:33:36 | Re: Postgresql Caching |
Previous Message | Craig A. James | 2006-10-15 23:55:54 | Re: Hints proposal |
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Armin Massa | 2006-10-16 09:15:58 | measuring shared memory usage on Windows |
Previous Message | Craig A. James | 2006-10-15 23:55:54 | Re: Hints proposal |