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:
>
>
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
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
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