Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C07759FB37B for ; Wed, 11 Oct 2006 12:03:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 38192-06 for ; Wed, 11 Oct 2006 12:03:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from wolff.to (wolff.to [66.93.197.194]) by postgresql.org (Postfix) with SMTP id 3BEDC9FB2AF for ; Wed, 11 Oct 2006 12:03:51 -0300 (ADT) Received: (qmail 11060 invoked by uid 500); 11 Oct 2006 15:14:39 -0000 Date: Wed, 11 Oct 2006 10:14:39 -0500 From: Bruno Wolff III To: Fourat Zouari Cc: "Jim C. Nasby" , Bricklen Anderson , pgsql-novice@postgresql.org, pgsql-admin@postgresql.org Subject: Re: Copying data from table to table (cloned tables) Message-ID: <20061011151439.GA11039@wolff.to> Mail-Followup-To: Bruno Wolff III , Fourat Zouari , "Jim C. Nasby" , Bricklen Anderson , pgsql-novice@postgresql.org, pgsql-admin@postgresql.org References: <621eda8a0610091651oc78994fy2b358260f5c9b58a@mail.gmail.com> <452AE2FF.1020409@presinet.com> <20061010152457.GG72517@nasby.net> <20061010153724.GI72517@nasby.net> <621eda8a0610110430y5be06e22t27d6c99991e86dc8@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <621eda8a0610110430y5be06e22t27d6c99991e86dc8@mail.gmail.com> User-Agent: Mutt/1.4.2.1i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.045 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200610/83 X-Sequence-Number: 23386 On Wed, Oct 11, 2006 at 13:30:22 +0200, Fourat Zouari 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.)