Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 02DD61337B6E for ; Thu, 27 Jan 2011 08:35:35 -0400 (AST) 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 65096-02 for ; Thu, 27 Jan 2011 12:35:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40]) by mail.postgresql.org (Postfix) with ESMTP id 923B31337BA4 for ; Thu, 27 Jan 2011 08:35:27 -0400 (AST) Received: from alap2.localnet (p579FBC89.dip.t-dialin.net [87.159.188.137]) by mail.anarazel.de (Postfix) with ESMTPSA id 368C5448003; Thu, 27 Jan 2011 13:35:26 +0100 (CET) From: Andres Freund To: pgsql-performance@postgresql.org Subject: Re: High load, Date: Thu, 27 Jan 2011 13:35:24 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.38-rc2-andres-00019-gd315777; KDE/4.6.0; x86_64; ; ) Cc: =?iso-8859-1?q?C=E9dric_Villemain?= , Michael Kohl References: In-Reply-To: MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Message-Id: <201101271335.24645.andres@anarazel.de> 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: 201101/255 X-Sequence-Number: 42042 On Thursday, January 27, 2011 12:24:10 PM C=E9dric Villemain wrote: > > maintenance_work_mem =3D 512MB > 128MB is usualy enough Uhm, I don't want to be picky, but thats not really my experience. Sorts fo= r=20 index creation are highly dependent on a high m_w_m. Quite regularly I find= the=20 existing 1GB limit a probleme here... Andres