Re: [HACKERS] commitfest.postgresql.org

Decibel! <decibel@decibel.org>

From: decibel <decibel@decibel.org>
To: Brendan Jurd <direvus@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org, PostgreSQL WWW <pgsql-www@postgresql.org>
Date: 2009-07-10T15:19:38Z
Lists: pgsql-hackers
On Jul 9, 2009, at 12:35 PM, Brendan Jurd wrote:
> We don't AFAIK collect data about these events.  However, we could
> have certain actions trigger the creation of an automated comment
> (e.g., "Status changed to Committed by petere") and let the
> aforementioned comment view suffice for a "history".


Our main system at work does that; any kind of status is stored as a  
raw, text "note". It sucks. It makes trying to query for specific  
kinds of events difficult, and it wastes a bunch of space.

It's a lot better to record machine-readable information for machine- 
created events. If you want to present it all as one, I suggest a  
union view that turns the machine-understood data into a human- 
understandable text format.
-- 
Decibel!, aka Jim C. Nasby, Database Architect  decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828