Postgres Pro
Downloads
Home   >   mailing lists

LOCK TABLE & speeding up mass data loads - Mailing list pgsql-performance

From Ron Johnson
Subject LOCK TABLE & speeding up mass data loads
Date
Msg-id 1043521053.818.32.camel@haggis
Whole thread Raw
Responses Re: LOCK TABLE & speeding up mass data loads  (Rod Taylor <rbt@rbt.ca>)
List pgsql-performance
Tree view 
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.l.johnson@cox.net          |
| Jefferson, LA  USA      http://members.cox.net/ron.l.johnson  |
|                                                               |
| "Fear the Penguin!!"                                          |
+---------------------------------------------------------------+

pgsql-performance by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: WEIRD CRASH?!?!
Next
From: Rod Taylor
Date:
Subject: Re: LOCK TABLE & speeding up mass data loads