Re: Transaction costs?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Transaction costs?
Date: 2000-11-02 16:33:49
Message-ID: 25554.973182829@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Philip Warner <pjw(at)rhyme(dot)com(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-11-02 16:43:56 Re: CommandCounterIncrement
Previous Message Lamar Owen 2000-11-02 16:13:21 Re: More cvs branch problems