Re: [GENERAL] time series data

You have these choices:
- turn events into INSERTs and UPDATES on a table that represents a  single call
  You might have an events VIEW with INSTED OF insert/update triggers  so you can insert events as the interface for
updatingcalls.
 
- store the events and have a VIEW on the events table that gives you  rows that summarize each call
- both: store the events and the summaries of the calls
  You might have an events table with AFTER INSERT triggers to insert  or update the corresponding rows in the calls
table.

Nico
-- 


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general