Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C50A59FC157 for ; Fri, 20 Jul 2007 15:21:16 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 73804-03 for ; Fri, 20 Jul 2007 15:21:06 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 9AB8D9FB1D8 for ; Fri, 20 Jul 2007 15:21:07 -0300 (ADT) Received: (qmail 17959 invoked from network); 20 Jul 2007 14:24:11 -0400 Received: from unknown (HELO D1RPQZB1) (msteben@192.168.1.181) by mail.autorevenue.com with SMTP; 20 Jul 2007 14:24:11 -0400 From: "Mark Steben" To: Subject: row level locking Date: Fri, 20 Jul 2007 14:19:36 -0400 Message-ID: <009c01c7cafa$874c2e60$b501a8c0@D1RPQZB1> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_009D_01C7CAD9.003A8E60" X-Mailer: Microsoft Office Outlook 11 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.3790.2929 Thread-index: AcfK+ocv5PSYaNfNR7Gp3kbFWhAhxA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.036 tagged_above=0 required=5 tests=AWL=0.034, BAYES_50=0.001, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200707/232 X-Sequence-Number: 26213 This is a multi-part message in MIME format. ------=_NextPart_000_009D_01C7CAD9.003A8E60 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Hi listers, I have a table that is accessed by only one transaction. It has 1500 rows each time that it processes This transaction. As soon as this transaction ends, it waits 10 seconds and starts again. It has another maximum 1500 rows loaded. . My question is this: I believe a RowExclusive level lock is acquired 1500 times during each transaction. Is this true? Is there a way to disable RowExclusive locks and reduce overhead since only this transaction Accesses this table. I know there are ways to specify locking levels in other DBMSs. To page or table levels. We are currently at version 7.4.5. Thank you for your time, Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. ------=_NextPart_000_009D_01C7CAD9.003A8E60 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi listers,

I have a table that is accessed by only one transaction.  = It has 1500 rows each time that it processes

This transaction.  As soon as this transaction ends, it = waits 10 seconds and starts again. 

It has another maximum 1500 rows loaded. .  =

 

My question is this:  I believe a RowExclusive level lock = is acquired 1500 times during each = transaction.

Is this true?  Is there a way to disable RowExclusive locks = and reduce overhead since only this transaction

Accesses this table.   I know there are ways to = specify locking levels in other DBMSs. To page or table = levels.

We are currently at version 7.4.5.

 

Thank you for your time,

 

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

 

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is = prohibited.  If you have received this e-mail message in error, please reply to = the sender that you have received this e-mail message in error and then = delete it.  Thank you.

 

------=_NextPart_000_009D_01C7CAD9.003A8E60--