Re: [ADMIN] row level locking

2007-07-21 Thread Simon Riggs
On Fri, 2007-07-20 at 14:19 -0400, Mark Steben wrote: > We are currently at version 7.4.5. You should upgrade if you want better performance and scalability. Or maybe you should just use COPY? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---(end of bro

Re: [ADMIN] row level locking

2007-07-20 Thread Sibte Abbas
On 7/20/07, Mark Steben <[EMAIL PROTECTED]> wrote: 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 loa

[ADMIN] row level locking

2007-07-20 Thread Mark Steben
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 RowE