Thread: 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