Can I write Large Objects in parallel transactions?

Поиск
Список
Период
Сортировка
От u15074
Тема Can I write Large Objects in parallel transactions?
Дата
Msg-id 1048000471.3e7737d760728@webmail.hs-harz.de
обсуждение исходный текст
Ответы Re: Can I write Large Objects in parallel transactions?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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/


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Red Hat snubbed by Oracle
Следующее
От: u15074
Дата:
Сообщение: Causes an insert into a table with a unique column a tablelock or a rowlock?