Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-11-02 16:43:56
Subject: Re: CommandCounterIncrement
Previous:From: Lamar OwenDate: 2000-11-02 16:13:21
Subject: Re: More cvs branch problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group