Re: Dump restoration via archive files

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: Kamalraj Singh Madhan <kamalr(at)networkprograms(dot)com>, jason(at)tishler(dot)net, pgsql-performance(at)postgresql(dot)org
Subject: Re: Dump restoration via archive files
Date: 2003-12-01 15:23:53
Message-ID: 20031201071943.G44545@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Mon, 1 Dec 2003, Jeff wrote:

> On Mon, 1 Dec 2003 15:47:47 +0530
> "Kamalraj Singh Madhan" <kamalr(at)networkprograms(dot)com> 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2003-12-01 15:59:52 Re: cross table indexes or something?
Previous Message Erik Norvelle 2003-12-01 15:11:11 Re: My indexes aren't being used (according to EXPLAIN)