Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 5149B6329B6 for ; Thu, 2 Sep 2010 02:54:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 53623-08 for ; Thu, 2 Sep 2010 05:54:09 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from fep13.mx.upcmail.net (fep13.mx.upcmail.net [62.179.121.33]) by mail.postgresql.org (Postfix) with ESMTP id 042AF6318F3 for ; Thu, 2 Sep 2010 02:54:08 -0300 (ADT) Received: from edge04.upcmail.net ([192.168.13.239]) by viefep13-int.chello.at (InterMail vM.8.01.02.02 201-2260-120-106-20100312) with ESMTP id <20100902055406.BIXJ1353.viefep13-int.chello.at@edge04.upcmail.net>; Thu, 2 Sep 2010 07:54:06 +0200 Received: from wiesinger.com ([84.112.167.138]) by edge04.upcmail.net with edge id 1hu21f03H2zVakc04hu3Cn; Thu, 02 Sep 2010 07:54:06 +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 o825rTbw020250; Thu, 2 Sep 2010 07:53:29 +0200 Received: from localhost (gerhard@localhost) by bbs.intern (8.14.4/8.14.4/Submit) with ESMTP id o825rSVl020246; Thu, 2 Sep 2010 07:53:28 +0200 Date: Thu, 2 Sep 2010 07:53:28 +0200 (CEST) From: Gerhard Wiesinger To: Tom Lane cc: Pavel Stehule , Andreas Kretschmer , pgsql-performance@postgresql.org Subject: Re: Major performance problem after upgrade from 8.3 to 8.4 In-Reply-To: <12837.1283186981@sss.pgh.pa.us> Message-ID: References: <20100830072230.GA28373@tux> <11111.1283185373@sss.pgh.pa.us> <12837.1283186981@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: o825rTbw020250 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=V15LrGZDFsIOLQGhFSBQucROxfiwgIeIJ7AmZ+xKGd4= c=1 sm=0 a=-BBt41PQAQkA:10 a=ORa4HqFjfvEA:10 a=kj9zAlcOel0A:10 a=-ProOGmuAAAA:8 a=iuGT0LBCU3HEosaEQ1wA:9 a=ZPeXNIZtxd_dCHi8dTsA:7 a=VsbJcp4E9CmLwPTnAwGZSCSyeC4A: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/1 X-Sequence-Number: 40204 On Mon, 30 Aug 2010, Tom Lane wrote: > Gerhard Wiesinger 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. > I tried to get 8.3.11 ready again: # Problems with timezone on startup (Default not found) ./configure --with-system-tzdata=/usr/share cp ./src/backend/postgres /bin/postgres-8.3.11 su -l postgres -c "/bin/postgres-8.3.11 -p 54321 -D /var/lib/pgsql-old/data &" >> /var/lib/pgsql-old/pgstartup.log 2>&1 < /dev/null Problem is that PostgreSQL doesn't listen and take much CPU and also disk I/O. 8.3 was shut down cleanly. 8.4 runs in parallel. Are there any problems with shared buffer conflicts? PID USER PR NI VIRT SWAP RES CODE DATA SHR S %CPU %MEM TIME+ COMMAND 6997 postgres 20 0 113m 112m 1236 3688 1064 712 D 38.7 0.0 0:45.43 /bin/postgres-8.3.11 -p 54321 -D /var/lib/pgsql-old/data Any ideas? Thnx. Ciao, Gerhard -- http://www.wiesinger.com/