Skip site navigation (1) Skip section navigation (2)

Re: Increasing pattern index query speed

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: mweilguni(at)sime(dot)com, pgsql-performance(at)postgresql(dot)org
Subject: Re: Increasing pattern index query speed
Date: 2008-11-26 19:07:36
Message-ID: 492D9E78.9080902@archonet.com (view raw or flat)
Thread:
Lists: pgsql-performance
Andrus wrote:
> Richard and Mario,
> 
>> You can't use xxx_pattern_ops indexes for non-pattern tests.
> 
> I missed regular index. Sorry for that. Now issue with testcase is
> solved. Thank you very much.
> 
> I researched issue in live 8.1.4 db a bit more.
> Performed vacuum and whole db reindex.
> Tried several times to run two same pattern queries in quiet db.

And the results were?

> additonal condition

One problem at a time. Let's get the pattern-matching speed problems on
your live server sorted, then we can look at different queries.

-- 
  Richard Huxton
  Archonet Ltd

In response to

Responses

pgsql-performance by date

Next:From: AndrusDate: 2008-11-26 19:24:48
Subject: Re: Increasing pattern index query speed
Previous:From: AndrusDate: 2008-11-26 18:56:28
Subject: Re: Increasing pattern index query speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group