Re: Can I write Large Objects in parallel transactions?

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

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

Предыдущее
От: "Thiago Lima "
Дата:
Сообщение: Vacuum, slowqueries e tabe optimization
Следующее
От: Kurt Overberg
Дата:
Сообщение: Big insert/delete memory problems