X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A8ACC9DC9D0 for ; Fri, 20 Jan 2006 10:15:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 78711-04 for ; Fri, 20 Jan 2006 10:16:02 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.de [213.165.64.21]) by postgresql.org (Postfix) with SMTP id 4315E9DC889 for ; Fri, 20 Jan 2006 10:15:54 -0400 (AST) Received: (qmail invoked by alias); 20 Jan 2006 14:15:58 -0000 Received: from p54A65321.dip.t-dialin.net (EHLO athlon64) [84.166.83.33] by mail.gmx.net (mp020) with SMTP; 20 Jan 2006 15:15:58 +0100 X-Authenticated: #594052 Received: from localhost (HELO [127.0.0.1]) [127.0.0.1] by athlon64 (192.168.0.2) (userid 3) with ESMTP (Classic Hamster Version 2.1 Build 2.1.0.0) ; Fri, 20 Jan 2006 15:17:07 +0100 Message-ID: <43D0F0E3.6000403@gmx.de> Date: Fri, 20 Jan 2006 15:17:07 +0100 From: Stephan Vollmer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8) Gecko/20051201 Thunderbird/1.5 Mnenhy/0.7.3.0 MIME-Version: 1.0 CC: pgsql-general@postgresql.org Subject: Re: Creation of tsearch2 index is very slow References: <43D0ED57.1020608@gmx.de> In-Reply-To: <43D0ED57.1020608@gmx.de> X-Enigmail-Version: 0.94.0.0 OpenPGP: id=8D46FCF8 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig481D5E4C9CD077ADBCEAFFCE" X-Posting-Agent: Hamster/2.1.0.0 X-Y-GMX-Trusted: 0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.126 required=5 tests=[AWL=-0.063, MISSING_HEADERS=0.189] X-Spam-Score: 0.126 X-Spam-Level: X-Archive-Number: 200601/991 X-Sequence-Number: 89936 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig481D5E4C9CD077ADBCEAFFCE Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 --------------enig481D5E4C9CD077ADBCEAFFCE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFD0PDjjY05go1G/PgRAjYMAJ0YuNGNamZ7++9lkf2awfOVFOQCCwCgh5/S rIwVEHwO9NFxvHniWiKp7DU= =TKBt -----END PGP SIGNATURE----- --------------enig481D5E4C9CD077ADBCEAFFCE--