Re: [PERFORM] poor pefrormance with regexp searches on large tables

2011-08-12 Thread Grzegorz Blinowski
time (but only on the first search - i.e. before data is cached) Surprisingly, changing shared_mem from 24MB to 1 GB gave no apparent effect. Thanks once again for all your help!!! Regards, Greg On Thu, Aug 11, 2011 at 3:56 PM, Kevin Grittner wrote: > Grzegorz Blinowski wrote: > >

Re: [PERFORM] poor pefrormance with regexp searches on large tables

2011-08-11 Thread Grzegorz Blinowski
reload the entire db from backup to change the storage method? Regards, greg On Wed, Aug 10, 2011 at 7:17 PM, Kevin Grittner wrote: > Grzegorz Blinowski wrote: > > > the problem is not disk transfer/access but rather the way > > Postgres handles regexp queries. > > As a

Re: [PERFORM] poor pefrormance with regexp searches on large tables

2011-08-10 Thread Grzegorz Blinowski
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... Cheers, Greg On Wed, Aug 10, 2011 at 5:27 PM, Kevin Grittner wrote: > Grzegorz Blinowski wrote: > > > Some p

[PERFORM] poor pefrormance with regexp searches on large tables

2011-08-10 Thread Grzegorz Blinowski
Dear All, I have some problems with regexp queries performance - common sense tells me that my queries should run faster than they do. The database - table in question has 590 K records, table's size is 3.5GB. I am effectively querying a single attribute "subject" which has an average size of 2KB