Dne 10.8.2011 19:01, Grzegorz Blinowski napsal(a):
> However, changing shared_mem didn't help. We also checked system I/O
> stats during the query - and in fact there is almost no IO (even with
> suboptimal shared_memory). So the problem is not disk transfer/access
> but rather the way Postgres handles regexp queries... As I have wirtten
> it is difficult to rewrite the query syntax (the SQL generation in this
> app is quite complex), but it should be relatively easy to at least join
> all OR clauses into one regexp, I can try this from the psql CLI. I will
> post an update if anything interesting happens...
Can you post EXPLAIN ANALYZE, prefferably using explain.depesz.com?
Tomas