Can I write Large Objects in parallel transactions?

From: u15074 <u15074(at)hs-harz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Can I write Large Objects in parallel transactions?
Date: 2003-03-18 15:14:31
Message-ID: 1048000471.3e7737d760728@webmail.hs-harz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I want to have parallel transactions, that write large objects into different
tables. Since I'm writing into different tables, parallel writing shouldn't be
a problem (no table or row locks).
But as far as I know all large objects are stored in one systemtable.
So I suppose that this table will be locked when a large object is written.
This would mean that one of my parallel transactions has to wait while the
other one can write.
Is this as I suspect?

Thanks.

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message u15074 2003-03-18 15:23:14 Causes an insert into a table with a unique column a tablelock or a rowlock?
Previous Message Amir Becher 2003-03-18 15:03:54 Corrupt index