Re: [HACKERS] Query Hints? No thanks. Data hints?

2008-05-06 Thread Peter Eisentraut
Am Dienstag, 6. Mai 2008 schrieb Martijn van Oosterhout: > Cross-table correlations are easy for the second part, because it's > fairly simple to see where it could be used. However, no-one has come > up with an algorithm to produce a useful number to use. For others it's > harder. For an algorith

Re: [HACKERS] Query Hints? No thanks. Data hints?

2008-05-06 Thread Martijn van Oosterhout
On Sun, May 04, 2008 at 09:44:58PM +0200, Dimitri Fontaine wrote: > IIRC, I've read here in the past some attempts to begin a proposal on > the topic of data hints, allowing the user to describe his data in a > way ANALYZE can't figure out by itself, as e.g. "this column value is > tied to th

[HACKERS] Query Hints? No thanks. Data hints?

2008-05-04 Thread Dimitri Fontaine
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi -hackers, In another thread about "GUC parameter cursors_tuple_fraction", the debate seems to drift onto query hints. About which the consensus here is pretty clear and strong, no query hints in PostgreSQL, thanks, or we're never gonna have