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
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
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
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
-