| From: | Kaare Rasmussen <kaare(at)jasonic(dot)dk> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org, Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | "Florian G(dot) Pflug" <fgp(at)phlo(dot)org> |
| Subject: | Re: An Idea for planner hints |
| Date: | 2006-08-09 15:46:33 |
| Message-ID: | 200608091746.33905.kaare@jasonic.dk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)jasonic(dot)dk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-08-09 15:47:38 | Re: 8.2 features status |
| Previous Message | Bruce Momjian | 2006-08-09 15:36:47 | Re: 8.2 features status |