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 this

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 algorithm,

[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 a