Re: Performance regression between 8.3 and 8.4 on heavy text indexing

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Performance regression between 8.3 and 8.4 on heavy text indexing
Дата
Msg-id 17025.1251304185@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Performance regression between 8.3 and 8.4 on heavy text indexing  (gael@pilotsystems.net (Gaël Le Mignot))
Ответы Re: Performance regression between 8.3 and 8.4 on heavy text indexing  (Guillaume Smet <guillaume.smet@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
gael@pilotsystems.net (=?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

В списке pgsql-performance по дате отправления:

Предыдущее
От: gael@pilotsystems.net (Gaël Le Mignot)
Дата:
Сообщение: Re: Performance regression between 8.3 and 8.4 on heavy text indexing
Следующее
От: Hrishikesh (हृषीकेश मेहेंदळे)
Дата:
Сообщение: Performance issues with large amounts of time-series data