X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BB591D1B8B7 for ; Sat, 30 Aug 2003 00:40:45 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 76762-01 for ; Fri, 29 Aug 2003 21:40:18 -0300 (ADT) Received: from water.oasis.net.au (water.oasis.net.au [210.8.139.2]) by svr1.postgresql.org (Postfix) with ESMTP id AD4ABD1B8A4 for ; Fri, 29 Aug 2003 21:40:12 -0300 (ADT) Received: from oasis.net.au (localhost [127.0.0.1]) by water.oasis.net.au (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id LAA04651; Sat, 30 Aug 2003 11:07:43 +1000 X-Authentication-Warning: water.oasis.net.au: Host localhost [127.0.0.1] claimed to be oasis.net.au From: "Rudi Starcevic" To: "Alexander Priem" , Subject: Re: Indexing question Date: Sat, 30 Aug 2003 11:07:43 +1000 Message-Id: <20030830010743.M18111@oasis.net.au> In-Reply-To: <012f01c36dfa$0f4a8760$b696a8c0@APR> References: <012f01c36dfa$0f4a8760$b696a8c0@APR> X-Mailer: Open WebMail X-OriginatingIP: 203.221.163.92 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/514 X-Sequence-Number: 3330 Hi, > I have some tables (which can get pretty large) in which I want to > record 'current' data as well as 'historical' data. Another solution can be using a trigger and function to record every transaction to a 'logging' table. This way you'll have one 'current' table and one 'historical' table The 'historical' table will contain every transaction recorded from the current table. Regards Rudi.