X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6E4039FA278 for ; Wed, 24 May 2006 16:56:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 30245-01 for ; Wed, 24 May 2006 16:56:30 -0300 (ADT) X-Greylist: delayed 00:14:06.302555 by SQLgrey- Received: from smtp.blackducksoftware.com (nat.blackducksoftware.com [216.195.218.91]) by postgresql.org (Postfix) with ESMTP id 5C9729F9398 for ; Wed, 24 May 2006 16:56:29 -0300 (ADT) Received: from [10.12.14.86] (tcook.blackducksoftware.com [10.12.14.86]) by smtp.blackducksoftware.com (Postfix) with ESMTP id 57D4A5C458C; Wed, 24 May 2006 15:57:08 -0400 (EDT) Message-ID: <4474BA71.8060404@blackducksoftware.com> Date: Wed, 24 May 2006 15:56:33 -0400 From: "Todd A. Cook" User-Agent: Mozilla Thunderbird 1.0.8 (X11/20060411) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Ruairi , pgsql-admin@postgresql.org Subject: Re: Restore of pg_dump taking a long time... References: <008c01c67f26$9848caf0$2815a8c0@D5T7W62J> <468.1148496451@sss.pgh.pa.us> <4474B721.8040101@blackducksoftware.com> <1126.1148500118@sss.pgh.pa.us> In-Reply-To: <1126.1148500118@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/342 X-Sequence-Number: 21874 Tom Lane wrote: > "Todd A. Cook" writes: >> I have found that increasing maintenance_work_mem can decrease index >> build speed on large tables: > > You should probably re-measure when 8.2 comes out; we've fixed a number > of performance issues in the sorting code that might cause that. Thanks. I'll do that. If I can, I'll try it sooner on a build from CVS. -- todd