Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 7FA686322DC
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  3 Sep 2010 02:08:47 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 57012-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri,  3 Sep 2010 05:08:40 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from fep16.mx.upcmail.net (fep16.mx.upcmail.net [62.179.121.36])
	by mail.postgresql.org (Postfix) with ESMTP id 989D16318F3
	for <pgsql-performance@postgresql.org>;
	Fri,  3 Sep 2010 02:08:39 -0300 (ADT)
Received: from edge02.upcmail.net ([192.168.13.237]) by viefep16-int.chello.at
	(InterMail vM.8.01.02.02 201-2260-120-106-20100312) with ESMTP
	id <20100903050837.SYMS1503.viefep16-int.chello.at@edge02.upcmail.net>;
	Fri, 3 Sep 2010 07:08:37 +0200
Received: from wiesinger.com ([84.112.167.138]) by edge02.upcmail.net with
 edge
	id 258Y1f02K2zVakc0258ZXa; Fri, 03 Sep 2010 07:08:37 +0200
X-SourceIP: 84.112.167.138
Received: from bbs.intern (localhost [127.0.0.1])
	by wiesinger.com (8.14.4/8.14.4) with ESMTP id o83578VU013427;
	Fri, 3 Sep 2010 07:07:08 +0200
Received: from localhost (gerhard@localhost)
	by bbs.intern (8.14.4/8.14.4/Submit) with ESMTP id o835776v013423;
	Fri, 3 Sep 2010 07:07:07 +0200
Date: Fri, 3 Sep 2010 07:07:07 +0200 (CEST)
From: Gerhard Wiesinger <lists@wiesinger.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
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: <21281.1283433278@sss.pgh.pa.us>
Message-ID: <alpine.LFD.2.01.1009030706080.13329@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>
	<12837.1283186981@sss.pgh.pa.us>
	<alpine.LFD.2.01.1009020749380.19625@bbs.intern>
	<21281.1283433278@sss.pgh.pa.us>
User-Agent: Alpine 2.01 (LFD 1266 2009-07-14)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-MailScanner-Information-wiesinger-com: Please contact the ISP for more
	information
X-wiesinger-com-MailScanner-ID: o83578VU013427
X-MailScanner-wiesinger-com: Found to be clean
X-MailScanner-SpamCheck-wiesinger-com: not spam, SpamAssassin (not cached,
	score=-4.399, required 4.5, autolearn=not spam, ALL_TRUSTED -1.80,
	BAYES_00 -2.60)
X-MailScanner-From: lists@wiesinger.com
X-Cloudmark-Analysis: v=1.1 cv=KBHyIoyMIRH440NzHl6uMYpbxJngTLC2P1JzLC/QbPg=
	c=1 sm=0 a=-BBt41PQAQkA:10 a=ORa4HqFjfvEA:10 a=kj9zAlcOel0A:10
	a=-ProOGmuAAAA:8 a=nn6ua0H1e3qVs_gbn5QA:9
	a=ZHDQaPSZV1Tw0guMPeXH1RJTTDgA:4 a=CjuIK1q_8ugA:10
	a=fU-A4pz3-wIA:10 a=HpAAvcLHHh0Zw7uRqdWCyQ==:117
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201009/4
X-Sequence-Number: 40207

On Thu, 2 Sep 2010, Tom Lane wrote:

> Gerhard Wiesinger <lists@wiesinger.com> writes:
>> Problem is that PostgreSQL doesn't listen and take much CPU and also disk
>> I/O. 8.3 was shut down cleanly.
>
> Hm, you sure about that?  What's in the postmaster log?

BTW: Do I need other postgres user with a different home directory?

Thnx.

Ciao,
Gerhard

--
http://www.wiesinger.com/