X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 198D152800 for ; Tue, 21 Jun 2005 12:22:35 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 33870-02 for ; Tue, 21 Jun 2005 15:22:29 +0000 (GMT) Received: from sccmmhc91.asp.att.net (sccmmhc91.asp.att.net [204.127.203.211]) by svr1.postgresql.org (Postfix) with ESMTP id E089B528D0 for ; Tue, 21 Jun 2005 12:22:28 -0300 (ADT) Received: from juju.arbash-meinel.com ([12.214.18.81]) by sccmmhc91.asp.att.net (sccmmhc91) with ESMTP id <20050621152228m9100nhn7oe>; Tue, 21 Jun 2005 15:22:28 +0000 Received: from [192.168.1.11] (mail [192.168.1.1]) by juju.arbash-meinel.com (Postfix) with ESMTP id A683B55FB6; Tue, 21 Jun 2005 10:22:27 -0500 (CDT) Message-ID: <42B830B3.6060902@arbash-meinel.com> Date: Tue, 21 Jun 2005 10:22:27 -0500 From: John A Meinel User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Yves Vindevogel Cc: pgsql-performance@postgresql.org Subject: Re: Another question on indexes (drop and recreate) References: <098952ec5af9b040acb9b6b5af743abd@implements.be> In-Reply-To: <098952ec5af9b040acb9b6b5af743abd@implements.be> X-Enigmail-Version: 0.92.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enig928D5216072CC4115B9F5CB9" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.035 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/392 X-Sequence-Number: 13029 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig928D5216072CC4115B9F5CB9 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Yves Vindevogel wrote: > Hi, > > I have another question regarding indexes. > > I have a table with a lot of indexes on it. Those are needed to=20 > perform my searches. > Once a day, a bunch of records is inserted in my table. > > Say, my table has 1.000.000 records and I add 10.000 records (1% new) > What would be faster. > > 1) Dropping my indexes and recreating them after the inserts > 2) Just inserting it and have PG manage the indexes > > Met vriendelijke groeten, > Bien =E0 vous, > Kind regards, > > *Yves Vindevogel* > *Implements* I'm guessing for 1% new that (2) would be faster. John =3D:-> --------------enig928D5216072CC4115B9F5CB9 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.0 (Cygwin) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCuDCzJdeBCYSNAAMRAprWAJ4g9RSvBE1It6Vn1sFCL1XMwGcv9gCglDDi GPXqYmu+uF46/Aj0QwoX+bE= =1C20 -----END PGP SIGNATURE----- --------------enig928D5216072CC4115B9F5CB9--