Skip site navigation (1) Skip section navigation (2)

Re: LOCK TABLE & speeding up mass data loads

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: Re: LOCK TABLE & speeding up mass data loads
Date: 2003-01-25 19:07:46
Message-ID: 1043521665.58142.135.camel@jester (view raw or flat)
Thread:
Lists: pgsql-performance
On Sat, 2003-01-25 at 13:57, Ron Johnson wrote:
> Hi,
> 
> 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
course).

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

Responses

pgsql-performance by date

Next:From: Ron JohnsonDate: 2003-01-25 19:19:09
Subject: Re: LOCK TABLE & speeding up mass data loads
Previous:From: Ron JohnsonDate: 2003-01-25 18:57:33
Subject: LOCK TABLE & speeding up mass data loads

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group