Re: Copying data from table to table (cloned tables) - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Copying data from table to table (cloned tables)
Date
Msg-id 20061011151439.GA11039@wolff.to
Whole thread Raw
In response to Re: Copying data from table to table (cloned tables)  ("Fourat Zouari" <fourat@gmail.com>)
List pgsql-admin
On Wed, Oct 11, 2006 at 13:30:22 +0200,
  Fourat Zouari <fourat@gmail.com> wrote:
> what's the benefits using a serialized trans ?

All of the queries in the transaction see a consistant view of the database.
So that two identical select queries will return the same information
within a serialized transaction. (As long as the current transaction doesn't
make any changes between the two selects that would affect their output.)

pgsql-admin by date:

Previous
From: "Sebastian Reitenbach"
Date:
Subject: Re: postgres in HA constellation
Next
From: "Jim C. Nasby"
Date:
Subject: Re: postgres in HA constellation