Re: The optimizer is too smart for me - How can I trick it? - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: The optimizer is too smart for me - How can I trick it?
Date
Msg-id 20080530163021.GC18339@svana.org
Whole thread Raw
In response to The optimizer is too smart for me - How can I trick it?  ("Peter Vanderborght" <peter.vanderborght@taatu.com>)
List pgsql-general
On Fri, May 30, 2008 at 10:49:21AM +0200, Peter Vanderborght wrote:
> What can I do to tell the optimizer to keep its hands off my query or at
> least get it to not optimize?

The usual trick is you put an OFFSET 0 in the subquery, which prevents
the optimiser from pulling it up.

Have a nice day.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: Gerhard Wiesinger
Date:
Subject: Re: Tsearch2 Upgrade from 8.2 to 8.3.1 with mediawiki
Next
From: "Merlin Moncure"
Date:
Subject: Re: Query planning configuration and solid state drives