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 DB3D79DC948 for ; Tue, 28 Mar 2006 14:09:42 -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 22749-05 for ; Tue, 28 Mar 2006 14:09:40 -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 883DA9DC852 for ; Tue, 28 Mar 2006 14:09:38 -0400 (AST) Received: by noel.decibel.org (Postfix, from userid 1001) id 2EB1356431; Tue, 28 Mar 2006 12:09:38 -0600 (CST) Received: (hashcash-sendmail, from uid 1001); Tue, 28 Mar 2006 12:09:37 -0600 Date: Tue, 28 Mar 2006 12:09:37 -0600 From: "Jim C. Nasby" To: Andy Shellam Cc: 'Rafael Martinez Guerrero' , pgsql-admin@postgresql.org Subject: Re: Bloated pg_shdepend_depender_index Message-ID: <20060328180937.GS75181@pervasive.com> References: <1143547721.24060.112.camel@bbking.uio.no> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: 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:andy.shellam@mailnetwork.co.uk::HOHKAwqMvex5M2hA:0000000 0000000000000000000000000Evw X-Hashcash: 1:20:060328:r.m.guerrero@usit.uio.no::Fuo4fPSbcK/48Jx2:0000000000000 0000000000000000000000000qDz X-Hashcash: 1:20:060328:pgsql-admin@postgresql.org::lCcZG4+ZYEJjeP2o:00000000000 0000000000000000000000000sHQ 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/311 X-Sequence-Number: 21068 On Tue, Mar 28, 2006 at 03:54:30PM +0100, Andy Shellam wrote: > QUOTE: > Exactly this issue and that you have to make a 'full' dump/restore > between major release is a big minus I hear everywhere I > explain/discuss about postgres for 24/7 and big databases. > END QUOTE > > Yes but how often does a major release come out? 17th Jan 2005 was the > first date of 8.0 according to the FTP site, with 8.1 out in November 2005. > If it takes a whole day to do a dump/restore, that's only one day out of > about 270 or more. Uh, for many sites minutes of downtime would be a huge issue, let alone hours. Fortunately, you can use Slony to migrate between versions, greatly reducing downtime. -- 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