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 2C5D152812 for ; Tue, 21 Jun 2005 13:55:05 -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 51210-09 for ; Tue, 21 Jun 2005 16:54:59 +0000 (GMT) Received: from sccmmhc91.asp.att.net (sccmmhc91.asp.att.net [204.127.203.211]) by svr1.postgresql.org (Postfix) with ESMTP id 8694D52871 for ; Tue, 21 Jun 2005 13:54:58 -0300 (ADT) Received: from juju.arbash-meinel.com ([12.214.18.81]) by sccmmhc91.asp.att.net (sccmmhc91) with ESMTP id <20050621165458m9100nh2l3e>; Tue, 21 Jun 2005 16:54:58 +0000 Received: from [192.168.1.11] (mail [192.168.1.1]) by juju.arbash-meinel.com (Postfix) with ESMTP id 1F18C55FB6; Tue, 21 Jun 2005 11:54:56 -0500 (CDT) Message-ID: <42B8465F.1020506@arbash-meinel.com> Date: Tue, 21 Jun 2005 11:54:55 -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> <42B830B3.6060902@arbash-meinel.com> <821370985653dc1f4166ca634f642ce2@implements.be> <42B83708.2050706@arbash-meinel.com> <09f30bc29a91c94eecaf7f70aa0c8399@implements.be> In-Reply-To: <09f30bc29a91c94eecaf7f70aa0c8399@implements.be> X-Enigmail-Version: 0.92.0.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigF80CC9D3606B2887161602A5" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/401 X-Sequence-Number: 13038 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigF80CC9D3606B2887161602A5 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Yves Vindevogel wrote: > I only add records, and most of the values are "random" > Except the columns for dates, .... I doubt that you would need to recreate indexes. That really only needs to be done in pathological cases, most of which have been fixed in the latest postgres. If you are only inserting (never updating or deleting), the index can never bloat, since you are only adding new stuff. (You cannot get dead items to bloat your index if you never delete anything.) John =:-> --------------enigF80CC9D3606B2887161602A5 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 iD8DBQFCuEZfJdeBCYSNAAMRAoZ0AJkBFSl9uz+Pihz9fnsDxEMz7Hdf9wCgwaBu 1tdTKjcPOJeSJS0nSCeNrJY= =iOQm -----END PGP SIGNATURE----- --------------enigF80CC9D3606B2887161602A5--