Re: [PERFORM] setting up foreign keys

2006-08-11 Thread Sue Fitt
Solved, it turned out to be a lock caused by a gui connected to the database, even though the gui wasn't actually doing anything at the time... Sue Stephan Szabo wrote: On Thu, 10 Aug 2006, Sue Fitt wrote: Hi all, This is my first post to the performance list, I hope someone can he

Re: [PERFORM] setting up foreign keys

2006-08-10 Thread Sue Fitt
ation (using integer id's rather than words) that bring: bring brought: see bring sing: sing sang: see sing etc. Sue Chris wrote: Sue Fitt wrote: Thanks Chris and Chris, you've solved it. I had a gui open that connects to the database. It was doing nothing (and not preven

Re: [PERFORM] setting up foreign keys

2006-08-10 Thread Sue Fitt
Thanks Chris and Chris, you've solved it. I had a gui open that connects to the database. It was doing nothing (and not preventing me adding to or altering headwords_core via psql), but having closed it the table is instantly created. Weird. BTW, referencing the same column twice is deliberat

[PERFORM] setting up foreign keys

2006-08-10 Thread Sue Fitt
e with 360 lines the new table is created almost instantly. I found a post on a similar subject from quite a while ago, but no answer, and that was for millions of rows anyway. I only have 13,000. Surely it should be faster than this? Is there a way to speed it up? Sue Fitt -