On Mon, 17 Nov 2003, Jeff wrote: > On Mon, 17 Nov 2003 10:40:20 -0800 (PST) > Stephan Szabo <[EMAIL PROTECTED]> 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.
Yeah. At the start of the discussion I believe 7.4RC2 was mentioned as the version which is why I'm surprised at the difference in times. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
