X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0992F3A553F; Wed, 1 Dec 2004 15:39:06 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56515-03; Wed, 1 Dec 2004 15:39:00 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 1E2B53A5423; Wed, 1 Dec 2004 15:38:59 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id iB1Fcbps008362; Wed, 1 Dec 2004 10:38:37 -0500 (EST) To: Shridhar Daithankar Cc: grupos@carvalhaes.net, pgsql-general@postgresql.org, pgsql-performance@postgresql.org Subject: Re: [PERFORM] pg_restore taking 4 hours! In-reply-to: <200412011955.23543.ghodechhap@ghodechhap.net> References: <41ADA82A.7070405@carvalhaes.net> <200412011955.23543.ghodechhap@ghodechhap.net> Comments: In-reply-to Shridhar Daithankar message dated "Wed, 01 Dec 2004 19:55:23 +0530" Date: Wed, 01 Dec 2004 10:38:37 -0500 Message-ID: <8361.1101915517@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200412/54 X-Sequence-Number: 69666 Shridhar Daithankar writes: > On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote: >> I need to find a solution for this because I am convincing customers >> that are using SQL Server, DB2 and Oracle to change to PostgreSQL but >> this customers have databases of 5GB!!! I am thinking that even with a >> better server, the restore will take 2 days! > Can you try bumping sort mem lot higher(basically whatever the machine can > afford) so that index creation is faster? It would be a good idea to bump up vacuum_mem as well. In current sources it's vacuum_mem (well actually maintenance_work_mem) that determines the speed of CREATE INDEX; I forget just how long that behavior has been around, but 7.4.6 might do it too. regards, tom lane