Table design question...

From: Joerg Hessdoerfer <Joerg(dot)Hessdoerfer(at)sea-gmbh(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Table design question...
Date: 2002-08-06 07:33:58
Message-ID: 200208060737.JAA20365@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, all!

Ok, I've banged my head on this, and would like to hear some opinion from the
list (I'm just short of trying it, though I don't have the hardware yet).

We have along running data logging application, where we essentially get data
records at varying speeds from a facility.
The data can be treated as arrays of floats, arrays of strings or binary
dumps, where each element in the arrays represent one value.
Additionally, there is the possibility of having a varying number of
'multisampler' values in one packet, where each value itself is an array.
Note, that in one packet the arrays need not be of same length!

So, this gives me at least 2 tables for the data, one that can handle the
'scalar' data (float, string, binary) and one that needs an array for every
value (floats only).

All data will have two time stamps (facility and receive times), as data may
be sent off-line to the logger.

So, all this boils down to the simple question: Is it better (in terms of
indices) to have a seperate table for the time stamps and join the data to it
via an foreign key id field, or have both timestamps in each data table?
What if I would create more data tables?

Please keep in mind, that I expect to have multi-million records in each
table ;-)

Thx,
Joerg
--
Leading SW developer - S.E.A GmbH
Mail: joerg(dot)hessdoerfer(at)sea-gmbh(dot)com
WWW: http://www.sea-gmbh.com

Browse pgsql-general by date

  From Date Subject
Next Message Ben-Nes Michael 2002-08-06 09:47:26 Return num of deleted rows from function
Previous Message Justin Clift 2002-08-06 05:12:32 Who here is an AUUG member? (Australian Unix Users Group)