From: Richard Huxton <dev@archonet.com>
To: Andrus <kobruleht2@hot.ee>
Cc: mweilguni@sime.com
Cc: pgsql-performance@postgresql.org
Subject: Re: Increasing pattern index query speed
Date: Wed, 26 Nov 2008 19:07:36 +0000
Message-ID: <492D9E78.9080902@archonet.com> (raw)
In-Reply-To: <4936D68EF8C84087BBB9212C4019D5D8@andrusnotebook>
References: <gg9pg5$1edv$1@news.hub.org>
<492A7591.3000700@archonet.com>
<C2F601D897194339A0D2327188C781D6@andrusnotebook>
<492D27C8.7090206@archonet.com>
<4936D68EF8C84087BBB9212C4019D5D8@andrusnotebook>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, kobruleht2@hot.ee, mweilguni@sime.com
Subject: Re: Increasing pattern index query speed
In-Reply-To: <492D9E78.9080902@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox