"Alexandru Coseru" <[EMAIL PROTECTED]> writes:
> Anyway , anybody has a clue why this regex is that CPU intensive ?
The EXPLAIN result you posted offers *no* evidence that the regexp is
CPU intensive. All you know is that it took 850+ msec to fetch 5200
rows from disk and apply the regexp filter to them. There's no evidence
here that that was CPU time and not I/O time.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
