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