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 5EA1B11F65A1 for ; Tue, 28 Mar 2006 19:17:11 -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 31814-10 for ; Tue, 28 Mar 2006 19:17:10 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id BC63811F65A4 for ; Tue, 28 Mar 2006 19:17:08 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 8C8A156423; Tue, 28 Mar 2006 17:17:08 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Tue, 28 Mar 2006 17:17:08 -0600 Date: Tue, 28 Mar 2006 17:17:08 -0600 From: "Jim C. Nasby" To: Rafael Martinez Cc: Scott Marlowe , pgsql-admin@postgresql.org Subject: Re: Bloated pg_shdepend_depender_index Message-ID: <20060328231707.GA561@pervasive.com> References: <1143547721.24060.112.camel@bbking.uio.no> <20060328180937.GS75181@pervasive.com> <1143575509.18329.13.camel@linux.site> <1143580500.3625.92.camel@state.g2switchworks.com> <1143587159.18329.56.camel@linux.site> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1143587159.18329.56.camel@linux.site> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060328:r.m.guerrero@usit.uio.no::0TA9DKMqSAJu7h10:0000000000000 0000000000000000000000002W0D X-Hashcash: 1:20:060328:smarlowe@g2switchworks.com::bEeRJxq9bkffR084:00000000000 00000000000000000000000018MX X-Hashcash: 1:20:060328:pgsql-admin@postgresql.org::Y7gjvM86p2Rk6v3+:00000000000 00000000000000000000000006MJ X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.108 required=5 tests=[AWL=0.108] X-Spam-Score: 0.108 X-Spam-Level: X-Archive-Number: 200603/326 X-Sequence-Number: 21083 On Wed, Mar 29, 2006 at 01:05:59AM +0200, Rafael Martinez wrote: > I work with postgresql every day and I am very happy with it, but this > does not mean I can not see the issues that could be improve to have a > even better open source DBMS. And I think in my humble opinion that > bloated indexes + better upgrade procedures between major releases are > two things that should get improved in the future. FWIW, I don't know of any upgrade procedures for databases that can quickly do an in-place upgrade when underlying file structures change, because ultimately you need to read and write the entire database on-disk. And unless you're going to be real gutsy, you'll also need a good amount of extra storage somewhere, unless you plan on doing this in-place upgrade without any backups. And at that point, you almost might as well just do a dump and reload. Given that, I don't think setting up a temporary Slony cluster to go between major versions is that big a deal. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461