Re: pg_restore and FK constraints with large dbs

On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com> wrote:

>
> By the way, what does your schema look like? I created an 80M row fk
> table and 20K row pk table with an int4 key between them and indexes on
> the two key fields. It took about 25 minutes on my not terribly fast
> system using 7.4b5 to make the foreign key between them. It might have
> been faster if I'd raised sort_mem to something larger than 8192.
>

i missed the start of this thread... but unless you are running 7.4 adding an FK (restore) is very slow. ZIt is fixed in 7.4.. especially w/lots of sort mem.

But the need still exists for a faster backup & restore. I've had a couple threads on this in I think -admin and -performance listts.

> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

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