Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 02F902E3A32 for ; Wed, 19 Dec 2007 18:42:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 53579-01-2 for ; Wed, 19 Dec 2007 18:42:12 -0400 (AST) Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.181]) by postgresql.org (Postfix) with ESMTP id 80E2F2E3A16 for ; Wed, 19 Dec 2007 18:42:43 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so839099ele.5 for ; Wed, 19 Dec 2007 14:42:42 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=EsSO/TBrxuk+YJmauL/VfkRCupp0A6P/OMsYNEHllqs=; b=FjwIZ0yavuUqKWZPNi88PwfZ1BtiLBR5PLv3KiUSm3G1cnbvBTMVPkh/JFPDP7E0O9kHcTdV5nmvWkj12lbcTBAZpSotgu912/GF5ZIVzQ5tgohjaiDBaTVNBl8/+z5HSfKTHdZlHJIb5lKG2ZbnS8r+Eek8RikV6/bLIkjr57M= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=sUqagL6mIVq8RbZ2rxIwV2bnAZRPft0SLzEPtGAMf3gEkdu2fvB9jdrhickSq/ixfkzDyL5q3Vyjd7lJ2xKs1LMsUA0lix4os7AUE7eQLoTWOi7KJA0mo1BHS5Foz6KOHgO2HAj6ZUtA/8grDhrasdXOVkPtCKuyeCFC7q0IQyI= Received: by 10.142.242.8 with SMTP id p8mr2240676wfh.70.1198104161637; Wed, 19 Dec 2007 14:42:41 -0800 (PST) Received: by 10.142.143.6 with HTTP; Wed, 19 Dec 2007 14:42:41 -0800 (PST) Message-ID: Date: Wed, 19 Dec 2007 16:42:41 -0600 From: "Scott Marlowe" To: "olivier.boissard@cerene.fr" Subject: Re: How to uses self query plan Cc: pgsql-admin@postgresql.org In-Reply-To: <476999FC.9090306@cerene.fr> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <476847DB.9090401@cerene.fr> <4768CEEF.9060506@cerene.fr> <476999FC.9090306@cerene.fr> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/183 X-Sequence-Number: 27700 On Dec 19, 2007 4:23 PM, 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 ? No, not what I meant! I meant to go to the latest 8.1 version. i.e. 8.1.0 has lots of bugs that 8.1.10 (or whatever the latest 8.1 is) has fixed. If you wanna migrate to 8.2.5 that would probably be ok, but 8.3 isn't quite done yet.