Re: [GENERAL] Replication Ideas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>, Chris Travers <chris(at)travelamericas(dot)com>, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Replication Ideas
Date: 2003-08-27 03:37:10
Message-ID: 6358.1061955430@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> If you can detect if outside transactions conflict with your
> transaction, you should be able to determine if the outside transactions
> conflict with each other.

Uh ... not necessarily. That amounts to assuming that every xact has
complete knowledge of the actions of every other, which is an assumption
I'd rather not make. Detecting that what you've done conflicts with
someone else is one thing, detecting that party B has conflicted with
party C is another league entirely.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-08-27 03:57:26 Re: [GENERAL] Replication Ideas
Previous Message Rudy Koento 2003-08-27 03:32:50 postgresql not using index even though it's faster

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-08-27 03:57:26 Re: [GENERAL] Replication Ideas
Previous Message Bruce Momjian 2003-08-27 03:25:41 Re: [GENERAL] Replication Ideas

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-08-27 03:57:26 Re: [GENERAL] Replication Ideas
Previous Message Bruce Momjian 2003-08-27 03:25:41 Re: [GENERAL] Replication Ideas