Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id EEC199F9FED for ; Wed, 22 Aug 2007 18:08:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 07301-04 for ; Wed, 22 Aug 2007 18:08:20 -0300 (ADT) X-Greylist: delayed 00:08:38.784902 by SQLgrey-1.7.5 Received: from mailgw1.fjfi.cvut.cz (mailgw1.fjfi.cvut.cz [147.32.9.3]) by postgresql.org (Postfix) with ESMTP id F3CA19F9624 for ; Wed, 22 Aug 2007 18:08:22 -0300 (ADT) Received: from localhost (localhost.localdomain [127.0.0.1]) by mailgw1.fjfi.cvut.cz (Postfix) with ESMTP id 4535943E0F for ; Wed, 22 Aug 2007 22:59:39 +0200 (CEST) X-CTU-FNSPE-Virus-Scanned: amavisd-new at fjfi.cvut.cz X-CTU-FNSPE: this_is_mailgw_for_ctu_fnspe_header X-CTU-FNSPE-Helo: [10.0.0.1] X-CTU-FNSPE-Client-Address: 85.207.117.155 X-CTU-FNSPE-Client-Name: 155-117-207-85.strcechy.adsl-llu.static.bluetone.cz X-CTU-FNSPE-Sender: konference@brinda.info X-CTU-FNSPE-Recip: pgsql-admin@postgresql.org Received: from mailgw1.fjfi.cvut.cz ([127.0.0.1]) by localhost (mailgw1.fjfi.cvut.cz [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id mTmRKsIrOFH0 for ; Wed, 22 Aug 2007 22:59:36 +0200 (CEST) Received: from [10.0.0.1] (155-117-207-85.strcechy.adsl-llu.static.bluetone.cz [85.207.117.155]) (using SSLv3 with cipher DES-CBC3-SHA (168/168 bits)) (No client certificate requested) (Authenticated sender: brinda) by mailgw1.fjfi.cvut.cz (Postfix) with ESMTP id ABE6943DBC for ; Wed, 22 Aug 2007 22:59:36 +0200 (CEST) Subject: Possibilities of PgSQL From: Karel =?UTF-8?Q?B=C5=99inda?= To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=ISO-8859-2 Date: Wed, 22 Aug 2007 22:59:37 +0200 Message-Id: <1187816377.4039.44.camel@karkulka> Mime-Version: 1.0 X-Mailer: Evolution 2.11.90 (2.11.90-2.fc8) Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200708/278 X-Sequence-Number: 26609 Hi, I have a question about PgSQL. I am working at some project and I want to have few tables with special properties: There would be many rows and these would be changed every day for many times. I want to be able to get know how did the row looked in given time (f.e. 2 day ago, 6 minutes ago, 2nd Sept. 2002,...). Nevertheless it should work with diffs (f.e. if I had a row with 100MB string and I changed only 2 chars it should not require on disk 200MB but only 100MB + few (kilo)Bytes). Is there any possibility how to solve it? I have heard that I can do it with triggers (but the worst thing is how to implement diffs) but I hope that there is any other (easier) way. Karel Bøinda