X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 49C5FD1B465 for ; Mon, 1 Dec 2003 15:24:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 22872-04 for ; Mon, 1 Dec 2003 11:24:08 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 75C84D1B43E for ; Mon, 1 Dec 2003 11:24:04 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id A7636355D6; Mon, 1 Dec 2003 07:23:53 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id A3F1E354CA; Mon, 1 Dec 2003 07:23:53 -0800 (PST) Date: Mon, 1 Dec 2003 07:23:53 -0800 (PST) From: Stephan Szabo To: Jeff Cc: Kamalraj Singh Madhan , jason@tishler.net, pgsql-performance@postgresql.org Subject: Re: Dump restoration via archive files In-Reply-To: <20031201091634.6f19f28a.threshar@torgo.978.org> Message-ID: <20031201071943.G44545@megazone.bigpanda.com> References: <4c0ccf4c27ff.4c27ff4c0ccf@jhmimail.jhmi.edu> <3FC54A82.2040605@familyhealth.com.au> <20031127032831.GA4836@gp.word-to-the-wise.com> <3FC58097.8090803@familyhealth.com.au> <20031127051230.GA6212@gp.word-to-the-wise.com> <20031128050417.GA14227@gp.word-to-the-wise.com> <3FC6DAB8.4080106@familyhealth.com.au> <20031128203700.GA19831@gp.word-to-the-wise.com> <3FC9BC76.2030308@familyhealth.com.au> <01d601c3b7f4$61897f10$4ecb09c0@KAMALR> <20031201091634.6f19f28a.threshar@torgo.978.org> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/9 X-Sequence-Number: 4869 On Mon, 1 Dec 2003, Jeff wrote: > On Mon, 1 Dec 2003 15:47:47 +0530 > "Kamalraj Singh Madhan" wrote: > > 4. If you are not using 7.4 and using pg_dump, there isn't much you can > do about adding foreign keys going stupidly slow :( You can take a schema dump and a separate data only dump where the latter specifies --disable-triggers which should disable the checks when the data is being added.