Search Postgresql Archives

Re: Discovering time of last database write

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Andy Dale" <andy.dale@xxxxxxxxx>
Subject: Re: Discovering time of last database write
From: "Michael Nolan" <htfoot@xxxxxxxxx>
Date: Mon, 8 Jan 2007 10:54:48 -0600
Cc: "Scott Marlowe" <smarlowe@xxxxxxxxxxxxxxxxx>, "Bruno Wolff III" <bruno@xxxxxxxx>, "pgsql general" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <faa313130701080842i273cd91ey672f52259297e0df@xxxxxxxxxxxxxx>
References: <faa313130701040911n788e15eeld3ed52fdfd1967c6@xxxxxxxxxxxxxx> <1167931470.3421.25.camel@xxxxxxxxxxxxxxxxxxxxxxx> <faa313130701080022m7acabc91g966b1dcf8eeea301@xxxxxxxxxxxxxx> <20070108084815.GA6441@xxxxxxxx> <faa313130701080126k732feb0ned382448c922732@xxxxxxxxxxxxxx> <1168273367.20602.9.camel@xxxxxxxxxxxxxxxxxxxxxxx> <faa313130701080842i273cd91ey672f52259297e0df@xxxxxxxxxxxxxx>

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Discovering time of last database write
  - From: Andy Dale
- Re: Discovering time of last database write
  - From: Scott Marlowe
- Re: Discovering time of last database write
  - From: Andy Dale
- Re: Discovering time of last database write
  - From: Bruno Wolff III
- Re: Discovering time of last database write
  - From: Andy Dale
- Re: Discovering time of last database write
  - From: Scott Marlowe
- Re: Discovering time of last database write
  - From: Andy Dale

Prev by Date: Re: More activity in pg_stat_activity
Next by Date: Re: More activity in pg_stat_activity
Previous by thread: Re: Discovering time of last database write
Next by thread: Re: Discovering time of last database write
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]