Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 7D968632449
	for <pgsql-performance-postgresql.org@mail.postgresql.org>; Mon, 30 Aug 2010 13:49:49 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
 by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024)
 with ESMTP id 07780-01
 for <pgsql-performance-postgresql.org@mail.postgresql.org>;
 Mon, 30 Aug 2010 16:49:42 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by mail.postgresql.org (Postfix) with ESMTP id 5AD2A63226D
	for <pgsql-performance@postgresql.org>; Mon, 30 Aug 2010 13:49:42 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o7UGnfAd012838;
	Mon, 30 Aug 2010 12:49:41 -0400 (EDT)
To: Gerhard Wiesinger <lists@wiesinger.com>
cc: Pavel Stehule <pavel.stehule@gmail.com>,
        Andreas Kretschmer <akretschmer@spamfence.net>,
        pgsql-performance@postgresql.org
Subject: Re: Major performance problem after upgrade from 8.3 to 8.4 
In-reply-to: <alpine.LFD.2.01.1008301838480.4133@bbs.intern> 
References: <alpine.LFD.2.01.1008300802300.4121@bbs.intern> <20100830072230.GA28373@tux> <AANLkTi=Te9ToTG-bqVy+fHQ0wM1YWv0nhBqqYiTk2ePg@mail.gmail.com> <alpine.LFD.2.01.1008300956320.19598@bbs.intern> <AANLkTik14X_MYoZA5CHNGC8M7Rc0zXrRhoGw6FrfUPXm@mail.gmail.com> <alpine.LFD.2.01.1008301808330.31277@bbs.intern> <11111.1283185373@sss.pgh.pa.us> <alpine.LFD.2.01.1008301838480.4133@bbs.intern>
Comments: In-reply-to Gerhard Wiesinger <lists@wiesinger.com>
	message dated "Mon, 30 Aug 2010 18:45:26 +0200"
Date: Mon, 30 Aug 2010 12:49:41 -0400
Message-ID: <12837.1283186981@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
 T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201008/333
X-Sequence-Number: 40176

Gerhard Wiesinger <lists@wiesinger.com> writes:
> BTW: I have the old data setup. /var/lib/pgsql-old. Is there a fast setup 
> with old version on different TCP port possible to compare query plans?

You'll need to reinstall the old executables.  If you put the new
executables in the same directories, it's not going to be easy to
run both in parallel.  If you didn't, then you just need to start
the old postmaster using a different port number.