Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 93E2463218A for ; Fri, 3 Sep 2010 13:40:01 -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 79604-04 for ; Fri, 3 Sep 2010 16:39:53 +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 430676321B7 for ; Fri, 3 Sep 2010 13:39:53 -0300 (ADT) Received: from edge04.upcmail.net ([192.168.13.239]) by viefep16-int.chello.at (InterMail vM.8.01.02.02 201-2260-120-106-20100312) with ESMTP id <20100903163951.CGOH1503.viefep16-int.chello.at@edge04.upcmail.net>; Fri, 3 Sep 2010 18:39:51 +0200 Received: from wiesinger.com ([84.112.167.138]) by edge04.upcmail.net with edge id 2Gfc1f03y2zVakc04Gfgwt; Fri, 03 Sep 2010 18:39:51 +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 o83GcrE3028160; Fri, 3 Sep 2010 18:38:53 +0200 Received: from localhost (gerhard@localhost) by bbs.intern (8.14.4/8.14.4/Submit) with ESMTP id o83Gcr5r028156; Fri, 3 Sep 2010 18:38:53 +0200 Date: Fri, 3 Sep 2010 18:38:53 +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: <22001.1283523290@sss.pgh.pa.us> Message-ID: References: <20100830072230.GA28373@tux> <11111.1283185373@sss.pgh.pa.us> <12837.1283186981@sss.pgh.pa.us> <21281.1283433278@sss.pgh.pa.us> <22001.1283523290@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: o83GcrE3028160 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=2eZ8bzZU-nb6dMmSJgYA:9 a=Q3DsZ-Rnw9x3cehbYzIA:7 a=pvJr_ga31kuv8w3bqzPtL3zsC64A:4 a=CjuIK1q_8ugA: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/9 X-Sequence-Number: 40212 On Fri, 3 Sep 2010, Tom Lane wrote: > Not even in that pgstartup.log file you sent stderr to? > > I have seen cases before where Postgres couldn't log anything because of > SELinux. If this is a Red Hat based system, look in the kernel log for > AVC messages. If you see any, then SELinux is probably blocking things > because of the nonstandard directory locations. Turning it off > temporarily would be the easiest fix, though relabeling the files would > be a better one. SELinux is already disabled. cat /etc/selinux/config | grep -v "^#"|grep -v "^$" SELINUXTYPE=targeted SELINUX=disabled Yes, also the redirected log file is empty. Also kernel log is empty. I tried to redirect it to a different, new file, on startup I get nothing, after killing it I get: 2010-09-03 16:35:39.177 GMT [2149] @/: LOG: could not stat "/usr/share/doc/xalan-j2-manual-2.7.0/apidocs": No such file or directory Any ideas? BTW: Shared memory can't be any issue? Ciao, Gerhard -- http://www.wiesinger.com/