On Sat, 2003-01-25 at 13:57, Ron Johnson wrote:
> Would LOCK TABLE ACCESS EXCLUSIVE MODE speed things up, when I have
> a script that loads data by setting transactions, and then committing
> works after every few thousand INSERTs?
If you're the only person working on the database, then no. If you're
fighting for resources with a bunch of other people -- then possibly,
but the others won't get anything done during this timeframe (of
Oh, and you're using COPY right?
Rod Taylor <rbt(at)rbt(dot)ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
In response to
pgsql-performance by date
|Next:||From: Ron Johnson||Date: 2003-01-25 19:19:09|
|Subject: Re: LOCK TABLE & speeding up mass data loads|
|Previous:||From: Ron Johnson||Date: 2003-01-25 18:57:33|
|Subject: LOCK TABLE & speeding up mass data loads|