Re: [PERFORM] Estimation problem with a LIKE clause containing a / - Mailing list pgsql-hackers

From Guillaume Smet
Subject Re: [PERFORM] Estimation problem with a LIKE clause containing a /
Date
Msg-id 1d4e0c10711091257w401c95f4s5f63ae32daecd14e@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] Estimation problem with a LIKE clause containing a /  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom,

Just to confirm you that your last commit fixed the problem:

lbo=# explain analyze select * from cms_items where ancestors LIKE '1062/%';
                                                  QUERY PLAN
---------------------------------------------------------------------------------------------------------------
 Seq Scan on cms_items  (cost=0.00..688.26 rows=*9097* width=103)
(actual time=0.011..22.605 rows=11326 loops=1)
   Filter: ((ancestors)::text ~~ '1062/%'::text)
 Total runtime: 30.022 ms
(3 rows)

Thanks for your time.

--
Guillaume

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Latest xml patch breaks some of the buildfarm
Next
From: "Pavel Stehule"
Date:
Subject: last note to rewrite function