Groups > comp.databases.postgresql > #634

Re: pg_hint_plan

From	Mladen Gogala <gogala.mladen@gmail.com>
Newsgroups	comp.databases.postgresql
Subject	Re: pg_hint_plan
Date	2015-02-16 14:59 +0000
Organization	A noiseless patient Spider
Message-ID	<pan.2015.02.16.15.00.03@gmail.com> (permalink)
References	<pan.2015.02.16.14.08.17@gmail.com> <m261b2aq93.fsf@2ndQuadrant.fr>

Show all headers | View raw

On Mon, 16 Feb 2015 15:24:24 +0100, Dimitri Fontaine wrote:

> Again, as soon as you use hints, then you need to review every once in a
> while that they are still effective, because they won't be re-evaluated
> against data growth as the usual PostgreSQL statistics system are. Also
> each new version of PostgreSQL will come with a better planner and
> optimiser, so you will need to review all hints and remove the rotted
> ones. Yes, hints rot.

Yes, they indeed do rot. As I have said in my post, hints are only a fire 
fighting solution of the last resort. And they are necessary as such. My 
deepest gratitude goes to the author(s) of the extension who have made 
them available.

-- 
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com
Je suis Charlie

Back to comp.databases.postgresql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

pg_hint_plan Mladen Gogala <gogala.mladen@gmail.com> - 2015-02-16 14:07 +0000
  Re: pg_hint_plan Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2015-02-16 15:24 +0100
    Re: pg_hint_plan Mladen Gogala <gogala.mladen@gmail.com> - 2015-02-16 14:59 +0000
    Re: pg_hint_plan Robert Klemme <shortcutter@googlemail.com> - 2015-02-17 08:29 +0100

csiph-web