X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 6DF459DCC9B for ; Fri, 10 Feb 2006 20:03:27 -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 37725-09 for ; Fri, 10 Feb 2006 20:03:29 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from ns.snowman.net (ns.snowman.net [66.92.160.21]) by postgresql.org (Postfix) with ESMTP id 541CC9DCA35 for ; Fri, 10 Feb 2006 20:03:24 -0400 (AST) Received: by ns.snowman.net (Postfix, from userid 1000) id 3DC1F17AF9; Fri, 10 Feb 2006 19:04:27 -0500 (EST) Date: Fri, 10 Feb 2006 19:04:27 -0500 From: Stephen Frost To: david drummard Cc: pgsql-admin@postgresql.org Subject: Re: performance question related to pgsql Message-ID: <20060211000427.GI4474@ns.snowman.net> Mail-Followup-To: david drummard , pgsql-admin@postgresql.org References: <9c89e2490602101241i6a182491l53478521f15f7f8d@mail.gmail.com> <20060210204653.GH4474@ns.snowman.net> <9c89e2490602101326m60ce0930y9446cef99c45855e@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="rD+yDjN/1ll6mvAO" Content-Disposition: inline In-Reply-To: <9c89e2490602101326m60ce0930y9446cef99c45855e@mail.gmail.com> X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.4.24ns.3.0 (i686) X-Uptime: 19:00:43 up 244 days, 16:09, 13 users, load average: 0.05, 0.03, 0.00 User-Agent: Mutt/1.5.11 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.109 required=5 tests=[AWL=0.109] X-Spam-Score: 0.109 X-Spam-Level: X-Archive-Number: 200602/118 X-Sequence-Number: 20539 --rD+yDjN/1ll6mvAO Content-Type: text/plain; charset=us-ascii Content-Disposition: inline * david drummard (vijayspam@gmail.com) wrote: > thanks very much for the response. Are there any special commands to analyze > the index before using the table. If i rename the table, will the indexes > still stay with the table ( i hope so). You want to run 'analyze ' after you've created the index. Renaming the table will retain the indexes (and should retain everything else, analyze statistics, etc). The only issue you might need to be careful about is that renaming the table might not rename the indexes, in which case you might get errors when you try to create the new indexes about an index with that name already existing. Just be sure to test your scripts out w/ empty tables to make sure everything in the rotation works correctly so that when you add the data it all works correctly. By the way, there's a Postgres mailing list dedicated to Performance issues. These questions would probably be more appropriate there. Enjoy, Stephen --rD+yDjN/1ll6mvAO Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (GNU/Linux) iD8DBQFD7SoKrzgMPqB3kigRAv6UAJwOiDiR1+ZIb54BhBuTgOTybcq8PQCfS3KN IUhKOIQoYcZqNQpvSwDZ7is= =CtRp -----END PGP SIGNATURE----- --rD+yDjN/1ll6mvAO--