Postgres Pro
Downloads
Home   >   mailing lists

Estimating selectivity of predicates involving string pattern matching - Mailing list pgsql-novice

From Rajmohan C
Subject Estimating selectivity of predicates involving string pattern matching
Date
Msg-id CAHaqV0hBdkne2sQQb5SGwwPHV4yEY71pJvye7gsOnR61GCRV1g@mail.gmail.com
Whole thread Raw
List pgsql-novice
Tree view
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 by date:

Previous
From: Rajmohan C
Date:
Subject: how to find the order of joins from Explain command XML plan output in PostgreSQL9.3.4
Next
From: nikybolzo
Date:
Subject: collation from an external file