Re: An Idea for planner hints - Mailing list pgsql-hackers

From Kaare Rasmussen
Subject Re: An Idea for planner hints
Date
Msg-id 200608091746.33905.kaare@jasonic.dk
Whole thread Raw
In response to Re: An Idea for planner hints  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
> SELECT * FROM foo, bar WHERE pg_selectivity(foo.a = bar.a, 0.1);

ISTM that you introduced the Oracle silliness again, putting the hint into the 
query.

My suggestion would be to tell about it separately. Something like

CREATE HINT FOR JOIN foo, bar ON foo.a=bar.b AS <some hint>;

This way hints can be added and removed without ever touching the existing 
queries.

-- 

Med venlig hilsen
Kaare Rasmussen, Jasonic

Jasonic                 Telefon: +45 3816 2582
Nordre Fasanvej 12
2000 Frederiksberg      Email: kaare@jasonic.dk


pgsql-hackers by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: 8.2 features status
Next
From: "Joshua D. Drake"
Date:
Subject: Re: 8.2 features status