Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YpFJL-0008RL-K4 for pgsql-admin@arkaria.postgresql.org; Mon, 04 May 2015 12:17:23 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YpFJL-00088m-4x for pgsql-admin@arkaria.postgresql.org; Mon, 04 May 2015 12:17:23 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YpFJK-00088g-Ck for pgsql-admin@postgresql.org; Mon, 04 May 2015 12:17:22 +0000 Received: from mout.web.de ([212.227.17.12]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1YpFJH-00055b-UZ for pgsql-admin@postgresql.org; Mon, 04 May 2015 12:17:21 +0000 Received: from vm-mailsrv.lan.net ([87.155.100.102]) by smtp.web.de (mrweb103) with ESMTPSA (Nemesis) id 0MGicf-1Z29UN0mMT-00Daw9 for ; Mon, 04 May 2015 14:17:18 +0200 Received: from localhost (localhost [127.0.0.1]) by vm-mailsrv.lan.net (Postfix) with ESMTP id 13F64DF15 for ; Mon, 4 May 2015 14:17:17 +0200 (CEST) X-Spam-Flag: NO X-Spam-Score: -2.899 X-Spam-Level: X-Spam-Status: No, score=-2.899 tagged_above=-99.9 required=6.31 tests=[ALL_TRUSTED=-1, BAYES_00=-1.9, FREEMAIL_FROM=0.001] autolearn=ham autolearn_force=no Received: from vm-mailsrv.lan.net ([127.0.0.1]) by localhost (vm-mailsrv.lan.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id uOjJ_kxM2CXh for ; Mon, 4 May 2015 14:17:14 +0200 (CEST) Received: from neslonek.homeunix.org (vm-webapp-ext.dmz-lan.net [192.168.0.100]) by vm-mailsrv.lan.net (Postfix) with ESMTP id 5A533DF00 for ; Mon, 4 May 2015 14:17:14 +0200 (CEST) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Date: Mon, 04 May 2015 14:17:14 +0200 From: Jan Lentfer To: Subject: Re: =?UTF-8?Q?pg=5Fdump=20and=20pg=5Frestore=20with=20mul?= =?UTF-8?Q?tiple=20streams=20does=20Not=20seem=20to=20improve=20overall=20?= =?UTF-8?Q?times?= In-Reply-To: References: Message-ID: X-Sender: Jan.Lentfer@web.de User-Agent: Roundcube Webmail/0.7.2 X-Provags-ID: V03:K0:XK6gqa5Jlfk0yVo4ZkS1FgNsXHhg7Pt7Pih6mG+banRmulehGy9 zHgx3ylB0HQVU7+htJzrpxLKTesfYNPtS3r2gNYyr0gumkBkmYRBzcGkOODI+R9V2/RbDv2 KOApbUTwg5SWZuwSAhR+FqIsn2POhYkmgp/wZ0y96vhecT5BKFDKWFb3rD7HrKTWWr0/esK nd2Z7JupwkDsFCKxtnLKQ== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org Am 2015-05-01 17:16, schrieb Susan K. McClure: [...] > My postgresql.conf has these options for (hopefully) pg_dump and > pg_restore improvements: > > ================= > work_mem = 1GB # dump/restore Perf Value > #maintenance_work_mem = 2048MB # min 1MB > maintenance_work_mem = 1GB # dump/restore Perf Value > #autovacuum_work_mem = -1 # min 1MB, or -1 to use > maintenance_work_mem > > ... > fsync = off # dump/restore Perf Valuecheckpoint_segments = 60 # > dump/restore Perf Value > checkpoint_warning = 60s # dump/restore Perf Value > ...... > autovacuum = off # dump/restore Perf Value.. > ============================= > > Any thoughts on what else I might try to improve things ? [...] It ist more interesting to know how your database schema is. How many "large" tables do you have. What is e.g. the size of your 10,20,30 largest tables? Regards Jan -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin