gael@xxxxxxxxxxxxxxxx (=?iso-8859-1?Q?Ga=EBl?= Le Mignot) writes: > So it seems it was quite wrong about estimated matching rows (192 predicted, 10222 reals). Yup. What's even more interesting is that it seems the real win would have been to use just the 'claude & duviau' condition (which apparently matched only 14 rows). 8.3 had no hope whatever of understanding that, it just got lucky. 8.4 should have figured it out, I'm thinking. Does it help if you increase the statistics target for fulltext_tsv? (Don't forget to re-ANALYZE after doing so.) regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
