Re: Discovering time of last database write

From: "Michael Nolan" <htfoot(at)gmail(dot)com>
To: "Andy Dale" <andy(dot)dale(at)gmail(dot)com>
Cc: "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com>, "Bruno Wolff III" <bruno(at)wolff(dot)to>, "pgsql general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Discovering time of last database write
Date: 2007-01-08 16:54:48
Message-ID: 4abad0eb0701080854u6532934asfe995418f8771fcb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On several occasions I have thought that each row in a table should have a
SYSTEM COLUMN which gave the timestamp of the last update of that row. This
could get a bit expensive on space and in some cases might be redundant with
(or have a slightly different value from) a user-maintained timestamp field.

I have also thought that each table should have values for:

Last DDL
Last Insert
Last Update
Last Delete
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Erik Jones 2007-01-08 16:58:22 Re: More activity in pg_stat_activity
Previous Message Thomas F. O'Connell 2007-01-08 16:54:24 Re: More activity in pg_stat_activity