-Original Message-
From: Jeff Davis [mailto:[EMAIL PROTECTED]
Sent: Friday, October 13, 2006 1:00 PM
To: Alvaro Herrera
Cc: Bucky Jordan; josh@agliodbs.com; Jim C. Nasby; pgsql-
[EMAIL PROTECTED]
Subject: Re: [HACKERS] [PERFORM] Hints proposal
On Thu, 2006-10-12 at 18:02 -0400
I completely agree that it's much better *in the long run* to improve
the planner and the statistics system so that we don't need hints. But
there's been no plan put forward for how to do that, which means we
also
have no idea when some of these problems will be resolved. If someone
comes up
Well, one nice thing about the per-query method is you can post
before
and after EXPLAIN ANALYZE along with the hints.
One bad thing is that application designers will tend to use the hint,
fix
the immediate issue, and never report a problem at all. And query
hints
would not be
