Estimating selectivity of predicates involving string pattern matching

Поиск
Список
Период
Сортировка
От Rajmohan C
Тема Estimating selectivity of predicates involving string pattern matching
Дата
Msg-id CAHaqV0hBdkne2sQQb5SGwwPHV4yEY71pJvye7gsOnR61GCRV1g@mail.gmail.com
обсуждение исходный текст
Список pgsql-novice
Дерево обсуждения
I recently upgraded my machine from PostgreSQL8.3 to PostgreSQL9.3.4. After upgrade, when I ran TPC-H queries for performance testing, I could see drastic change in timings. Especially TPC-H query 5 which was taking 4 minutes to execute in pgsql8.3, took just 15 seconds in postgresql9.3.4. I think the reason it was taking 4 minutes in earlier version was because of the error in selectivity of string pattern matching predicate in the query. How was it fixed in recent version? Has any new algorithm been incorporated to handle this?

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

Предыдущее
От: Rajmohan C
Дата:
Сообщение: how to find the order of joins from Explain command XML plan output in PostgreSQL9.3.4
Следующее
От: nikybolzo
Дата:
Сообщение: collation from an external file