Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 451282E391F for ; Wed, 19 Dec 2007 18:35:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10328-07 for ; Wed, 19 Dec 2007 18:35:42 -0400 (AST) Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id 8AE852E3910 for ; Wed, 19 Dec 2007 18:35:42 -0400 (AST) Received: from [192.168.10.1] (ASte-Genev-Bois-153-1-104-173.w90-3.abo.wanadoo.fr [90.3.250.173]) by sd-2317.dedibox.fr (Postfix) with ESMTP id A330EAA49; Wed, 19 Dec 2007 23:35:40 +0100 (CET) Message-ID: <47699CBB.7080607@lelarge.info> Date: Wed, 19 Dec 2007 23:35:39 +0100 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.9 (X11/20071112) MIME-Version: 1.0 To: "olivier.boissard@cerene.fr" CC: Scott Marlowe , pgsql-admin@postgresql.org Subject: Re: How to uses self query plan References: <476847DB.9090401@cerene.fr> <4768CEEF.9060506@cerene.fr> <476999FC.9090306@cerene.fr> In-Reply-To: <476999FC.9090306@cerene.fr> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/182 X-Sequence-Number: 27699 olivier.boissard@cerene.fr wrote: > You're right . > I will begin by migrate postgresql version. > postgresql is now to 8.3 version . A lot of performance inprovements > have been made in this last version . > In any case I must do a pg_dump/pg_restore. > So , Should I try directly 8.3 version or is it more cautious to stay in > 8.1.x version ? > It mostly depends on you. PostgreSQL 8.3 is still in beta phase. So, if you're also on development stage, you can use 8.3. Otherwise, it's better to use the latest stable available, which means 8.2.5. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com