Re: Transaction costs?

Philip Warner <pjw@rhyme.com.au> writes:
> This is for pg_dump which, when restoring BLOBs, inserts multiple rows into
> a temporary xref table. The sequence of events is:

> Conn1: Begin
> Conn1: lo_create/lo_close/lo_write.../lo_close
> Conn2: Insert into xref table (which does an implicit begin/end, I think).
> Conn1: Commit;

Two connections?  Why in the world are you doing it like that --- and
especially in that order?  Seems like this is committing an xref change
before the LO itself is committed.  Why?
        regards, tom lane