Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5CC0763397B for ; Sat, 21 Feb 2009 09:45:42 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 47890-06 for ; Sat, 21 Feb 2009 09:45:38 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by mail.postgresql.org (Postfix) with SMTP id A7F0E63325B for ; Sat, 21 Feb 2009 09:45:34 -0400 (AST) Received: (qmail invoked by alias); 21 Feb 2009 13:45:30 -0000 Received: from dslc-082-082-161-170.pools.arcor-ip.net (EHLO [192.168.123.148]) [82.82.161.170] by mail.gmx.net (mp019) with SMTP; 21 Feb 2009 14:45:30 +0100 X-Authenticated: #955937 X-Provags-ID: V01U2FsdGVkX1+/9ZMSIZ+/5f2+pNKut58EBJ0dyGRTJO9vDn/y9y 3ur2UsESRmYNE3 Message-ID: <49A00574.3060702@gmx.de> Date: Sat, 21 Feb 2009 14:45:24 +0100 From: Jan-Peter Seifert User-Agent: Thunderbird 2.0.0.19 (Windows/20081209) MIME-Version: 1.0 To: Tena Sakai , pgsql-admin@postgresql.org Subject: Re: very, very slow performance References: <200902202145.49391.uwe@oss4u.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Y-GMX-Trusted: 0 X-FuHaFi: 0.75 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200902/173 X-Sequence-Number: 31394 Hello, > I have adjusted postgres parameters per your recommen- > dation. Work_mem is now 8GB, GB is just a typo I guess? Otherwise the value is insanely high. See: http://www.postgresql.org/docs/8.3/interactive/runtime-config-resource.html Peter