Re: Can I write Large Objects in parallel transactions?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: u15074 <u15074(at)hs-harz(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can I write Large Objects in parallel transactions?
Date: 2003-03-18 17:19:32
Message-ID: 20215.1048007972@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

u15074 <u15074(at)hs-harz(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kurt Overberg 2003-03-18 18:17:35 Big insert/delete memory problems
Previous Message Thiago Lima 2003-03-18 16:58:40 Vacuum, slowqueries e tabe optimization