Re: Dump restoration via archive files - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: Dump restoration via archive files
Date
Msg-id 20031201071943.G44545@megazone.bigpanda.com
Whole thread Raw
In response to Re: Dump restoration via archive files  (Jeff <threshar@torgo.978.org>)
List pgsql-performance
On Mon, 1 Dec 2003, Jeff wrote:

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

pgsql-performance by date:

Previous
From: Jeremiah Jahn
Date:
Subject: Re: cross table indexes or something?
Next
From: Erik Norvelle
Date:
Subject: Re: My indexes aren't being used (according to EXPLAIN)