Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 4E8922E301F for ; Wed, 19 Dec 2007 19:21:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 35778-07 for ; Wed, 19 Dec 2007 19:21:12 -0400 (AST) Received: from mx2.imatech.net (mx2.imatech.net [81.255.215.243]) by postgresql.org (Postfix) with ESMTP id 5467F2E2FA1 for ; Wed, 19 Dec 2007 19:17:47 -0400 (AST) Received: from mx.imatech.net ([81.255.215.253]:1931) by mx2.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Tue, 18 Dec 2007 23:38:18 +0100 X-AuthUser: olivier.boissard@cerene.fr Received: from [192.168.0.11] ([88.161.145.183]:2399) by mx.imatech.net with [XMail 1.23 ESMTP Server] id for from ; Thu, 20 Dec 2007 00:17:33 +0100 Message-ID: <4769A698.9070700@cerene.fr> Date: Thu, 20 Dec 2007 00:17:44 +0100 From: "olivier.boissard@cerene.fr" User-Agent: Thunderbird 1.5.0.13 (Windows/20070809) MIME-Version: 1.0 To: Guillaume Lelarge 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> <47699CBB.7080607@lelarge.info> In-Reply-To: <47699CBB.7080607@lelarge.info> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/184 X-Sequence-Number: 27701 Guillaume Lelarge a écrit : > 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. > > > I want in fact to make test on a server before , when validated migrate on production server , so 8.2.5 is more appropriate. Will I be able to keep my postgresql.conf file or is it not compatible ? Olivier .