X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D4D965E37CB for ; Wed, 18 Aug 2004 13:50:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58694-03 for ; Wed, 18 Aug 2004 16:50:14 +0000 (GMT) Received: from dbl.q-ag.de (dbl.q-ag.de [213.172.117.3]) by svr1.postgresql.org (Postfix) with ESMTP id E36A95E46EF for ; Wed, 18 Aug 2004 13:50:03 -0300 (ADT) Received: from [127.0.0.2] (dbl [127.0.0.1]) by dbl.q-ag.de (8.12.3/8.12.3/Debian-6.6) with ESMTP id i7IGnIuG005668; Wed, 18 Aug 2004 18:49:19 +0200 Message-ID: <4123895A.6060203@colorfullife.com> Date: Wed, 18 Aug 2004 18:52:42 +0200 From: Manfred Spraul User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr-FR; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Simon@2ndquadrant.com" Cc: Tom Lane , Bruce Momjian , Klaus Naumann , markw@osdl.org, "Pgsql-Hackers@Postgresql. Org" Subject: Re: NOT LOGGED options (was Point in Time Recovery ) References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=TO_ADDRESS_EQ_REAL X-Spam-Level: X-Archive-Number: 200408/1054 X-Sequence-Number: 58023 Simon@2ndquadrant.com wrote: >>Tom Lane wrote >> >> >>>NOT LOGGED options on CREATE INDEX and COPY, to allow users to take >>>advantage of the no logging optimization without turning off PITR system >>>wide. (Just as this is possible in Oracle and Teradata). >>> >>> >>Isn't this in direct conflict with your opinion above? And I cannot say >>that I think this one is a good idea. We do not have support for >>selective catalog xlogging; >> Is it possible to skip the xlog fsync for NOT LOGGED transactions? -- Manfred