"Alexandru Coseru" <alexandru.coseru@xxxxxxxxxxxxxxx> 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
