From: Tom Lane <tgl@sss.pgh.pa.us>
To: Stephan Vollmer <svollmer@gmx.de>
Cc: pgsql-general@postgresql.org
Subject: Re: Creation of tsearch2 index is very slow
Date: Fri, 20 Jan 2006 18:22:39 -0500
Message-ID: <6376.1137799359@sss.pgh.pa.us> (raw)
In-Reply-To: <43D114B1.5030802@gmx.de>
References: <43D0ED57.1020608@gmx.de>
<17454.1137771321@sss.pgh.pa.us>
<43D114B1.5030802@gmx.de>
Stephan Vollmer <svollmer@gmx.de> writes:
> Tom Lane wrote:
>> However, I'm not sure that anyone's tried to do any performance
>> optimization on the GIST insert code ... there might be some low-hanging
>> fruit there.
> Unfortunately, I'm not able to investigate it further myself as I'm
> quite a Postgres newbie. But I could provide someone else with the
> example table. Maybe someone else could find out why it is so slow.
The problem seems to be mostly tsearch2's fault rather than the general
GIST code. I've applied a partial fix to 8.1 and HEAD branches, which
you can find here if you're in a hurry for it:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00283.php
(the gistidx.c change is all you need for tsearch2)
There is some followup discussion in the pgsql-performance list. It
seems possible that we can get another factor of 10 or better with a
smarter picksplit algorithm --- but that patch will probably be too
large to be considered for back-patching into the stable branches.
regards, tom lane
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: tgl@sss.pgh.pa.us, svollmer@gmx.de, pgsql-general@postgresql.org
Subject: Re: Creation of tsearch2 index is very slow
In-Reply-To: <6376.1137799359@sss.pgh.pa.us>
* 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