"Alexandru Coseru" <alexandru(dot)coseru(at)totaltelecom(dot)ro> 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