Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 7A5311337B9C for ; Thu, 24 Mar 2011 11:13:13 -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 71827-06 for ; Thu, 24 Mar 2011 14:13:05 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51]) by mail.postgresql.org (Postfix) with ESMTP id 058B11337B8B for ; Thu, 24 Mar 2011 11:13:02 -0300 (ADT) Received: by tamriel.snowman.net (Postfix, from userid 1000) id 29C1D22995; Thu, 24 Mar 2011 10:13:03 -0400 (EDT) Date: Thu, 24 Mar 2011 10:13:03 -0400 From: Stephen Frost To: Uwe Bartels Cc: pgsql-performance@postgresql.org Subject: Re: maintenance_work_mem + create index Message-ID: <20110324141303.GE4116@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="LxJp/bhl+JFkkycE" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/2.6.32-5-amd64 (x86_64) X-Uptime: 10:09:11 up 49 days, 22:39, 30 users, load average: 0.05, 0.04, 0.00 User-Agent: Mutt/1.5.20 (2009-06-14) 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: 201103/308 X-Sequence-Number: 42987 --LxJp/bhl+JFkkycE Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Uwe, * Uwe Bartels (uwe.bartels@gmail.com) wrote: > So I checked this again and raised afterwards maintenance_work_mem step by > step up 64GB. > I logged in via psql, run the following statements > set maintenance_work_mem = '64GB'; I believe maintenance_work_mem suffers from the same problem that work_mem has, specifically that PG still won't allocate more than 1GB of memory for any single operation. Thanks, Stephen --LxJp/bhl+JFkkycE Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) iEYEARECAAYFAk2LUW8ACgkQrzgMPqB3kigZMwCfUVL/5nSdK5xiV+/SjWB6BG9B Fm0An2V5Tald8PUYXc5VIuKL/C1WNYTp =MSxh -----END PGP SIGNATURE----- --LxJp/bhl+JFkkycE--