LOCK TABLE & speeding up mass data loads

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>
Subject: LOCK TABLE & speeding up mass data loads
Date: 2003-01-25 18:57:33
Message-ID: 1043521053.818.32.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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?

Thanks,
Ron
--
+---------------------------------------------------------------+
| Ron Johnson, Jr. mailto:ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://members.cox.net/ron.l.johnson |
| |
| "Fear the Penguin!!" |
+---------------------------------------------------------------+

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rod Taylor 2003-01-25 19:07:46 Re: LOCK TABLE & speeding up mass data loads
Previous Message Andrew Sullivan 2003-01-25 18:44:12 Re: WEIRD CRASH?!?!