On Mon, 17 Nov 2003 10:40:20 -0800 (PST)
Stephan Szabo <sszabo@megazone.bigpanda.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
in7.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
-performancelistts.
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
--
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/http://www.stuarthamm.net/