From: Stephan Vollmer <svollmer@gmx.de>
Cc: pgsql-general@postgresql.org
Subject: Re: Creation of tsearch2 index is very slow
Date: Fri, 20 Jan 2006 15:17:07 +0100
Message-ID: <43D0F0E3.6000403@gmx.de> (raw)
In-Reply-To: <43D0ED57.1020608@gmx.de>
References: <43D0ED57.1020608@gmx.de>
PS:
What I forgot to mention was that inserting records into the table
is also about 2-3 times slower than before (most likely due to the
slow index update operations).
I dropped the whole database and restored the dumpfile, but the
result it the same. When the index is recreated after COPYing the
data, it takes more than 20 minutes for _each_ of both tsearch2
indexes. So the total time to restore this table is more than 45
minutes!
- Stephan
Attachments:
signature.asc (application/pgp-signature, 249B) download
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: svollmer@gmx.de, pgsql-general@postgresql.org
Subject: Re: Creation of tsearch2 index is very slow
In-Reply-To: <43D0F0E3.6000403@gmx.de>
* 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