News for hackers. Stuff that matters.
Re:Why PostgreSQL doesn't have query hints by btilly on Friday February 04, 2011 @04:47PM (#2181387)
No. Because in my particular situation I did not have DBA access, and I was running queries against a restored backup of an OLTP system. The risk/reward is such that it made absolutely no sense to try to tweak things to make my queries run faster at the potential cost of doing who knows what damage to the queries that were running in the OLTP system.

Therefore, even if I was still in that reporting role, I would never, ever even CONSIDER playing with the knob they gave me. And even were I so reckless, no sane DBA should allow it.

Re:Why PostgreSQL doesn't have query hints by brlewis on Friday February 04, 2011 @05:10PM (#2181486)
This snippet from the article makes me think their proposal only affects one query at a time:

For example, one which allowed you to put "SELECTIVITY 0.1" after a WHERE clause

Re:Why PostgreSQL doesn't have query hints by btilly on Friday February 04, 2011 @05:17PM (#2181519)
Oops, you're right.

Let me see. I can peer inside of a running black box and twiddle knobs that do something I don't understand until I magically get the right result. Then I can cross my fingers and hope it doesn't change out from under me.

Why does this not sound appealing?