Can I write Large Objects in parallel transactions?
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/
u15074 <u15074@hs-harz.de> writes:
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?
No, it isn't.
regards, tom lane