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 382CA11F62B9 for ; Tue, 28 Mar 2006 21:55:21 -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 58867-01 for ; Tue, 28 Mar 2006 21:55:20 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id AF0B711F6295 for ; Tue, 28 Mar 2006 21:55:18 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 29 Mar 2006 01:55:18 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 28 Mar 2006 19:55:18 -0600 Subject: Re: 7.4 --> 8.0/8.1 upgrade From: Scott Marlowe To: sh test Cc: pgsql-admin@postgresql.org In-Reply-To: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com> References: <20060329014729.64497.qmail@web37502.mail.mud.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1143597318.3625.123.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Tue, 28 Mar 2006 19:55:18 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.14 required=5 tests=[AWL=0.139, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.14 X-Spam-Level: X-Archive-Number: 200603/330 X-Sequence-Number: 21087 On Tue, 2006-03-28 at 19:47, sh test wrote: > Hello admins! > > i need to collect as much information > > pro/cons on a possible upgrade from > > 7.4 ---> 8.0/8.1 version > > Aside from getting our users vote on this, I wanted to ask you first > in order to collect any possible issues one might run into from > upgrading to such > versions. Downside: You gotta dump and reload, or use slony to minimize the downtime, but you need a spare machine to do that. Upside: Everything else. PostgreSQL 8.x series has a lot of performance improvements.