From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: Guillaume Smet <guillaume.smet@gmail.com>
Cc: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: pg_trgm performance
Date: Sat, 24 Feb 2007 01:31:05 +0100
Message-ID: <20070224003105.GA11010@uio.no> (raw)
In-Reply-To: <1d4e0c10702231509k7ad24e2ck3a149a2e3a2899f7@mail.gmail.com>
References: <82mz4k4mt7.fsf@mid.bfk.de>
<20070115125834.GA28248@uio.no>
<1d4e0c10702231509k7ad24e2ck3a149a2e3a2899f7@mail.gmail.com>
On Sat, Feb 24, 2007 at 12:09:41AM +0100, Guillaume Smet wrote:
> Could you try to see if the GIN implementation of pg_trgm is faster in
> your cases?
I'm sorry, I can no longer remember where I needed pg_trgm. Simple testing of
your patch seems to indicate that the GiN version is about 65% _slower_ (18ms
vs. 30ms) for a test data set I found lying around, but I remember that on
the data set I needed it, the GIST version was a lot slower than that (think
3-400ms). The 18 vs. 30ms test is a random Amarok database, on 8.2.3
(Debian).
Sorry I couldn't be of more help.
/* Steinar */
--
Homepage: http://www.sesse.net/
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: sgunderson@bigfoot.com, guillaume.smet@gmail.com, fweimer@bfk.de
Subject: Re: pg_trgm performance
In-Reply-To: <20070224003105.GA11010@uio.no>
* 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