Re: Adding foreign key performance

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Vivek Khera <khera(at)kcilink(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Adding foreign key performance
Date: 2003-10-28 19:25:24
Message-ID: 20031028142524.30e9e6fc.threshar@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 28 Oct 2003 14:22:04 -0500
Vivek Khera <khera(at)kcilink(dot)com> wrote:

> If you're restoring from a pg_dump -Fc (compressed dump) it already
> happens for you. The indexes and foreign keys are not added until the
> very end, from what I recall.
>

This happens with regular dumps - at the end is a pile of alter table's
that create the indices, FK's and triggers.

Is the -Fc method different?

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-10-29 01:47:28 Re: Adding foreign key performance
Previous Message Vivek Khera 2003-10-28 19:22:04 Re: Adding foreign key performance