Re: [HACKERS] Optimizer hints - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [HACKERS] Optimizer hints
Date
Msg-id 37A594BE.35F589F7@trust.ee
Whole thread Raw
In response to Optimizer hints  ("John Ridout" <johnridout@ctasystems.co.uk>)
Responses RE: [HACKERS] Optimizer hints
List pgsql-hackers
John Ridout wrote:
> 
> Hi,
> 
> I know of course that the pgsql optimizer is never wrong

:) 

OTOH, it is never completely right either :)

> but for the sake of argument do you think we could have
> optimizer hints the way say MSSQL has them?

I think it has been discussed (a little) but more on the 
lines of 'the way Oracle has them' ;)

It seems that this is not currently very high priority for 
any of the current real developers, but if you would 
contribute a nice clean implementation I'm sure it would 
be accepted.

----------------
Hannu


pgsql-hackers by date:

Previous
From: Oleg Broytmann
Date:
Subject: [GENERAL] database access authentication: crypted passwords
Next
From: "John Ridout"
Date:
Subject: RE: [HACKERS] Optimizer hints