Skip site navigation (1) Skip section navigation (2)

Re: Need help to organize database

From: "Vladimir S(dot) Petukhov" <vladimir(at)sycore(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Need help to organize database
Date: 2004-12-22 00:16:06
Message-ID: 200412220016.06586.vladimir@sycore.org (view raw or flat)
Thread:
Lists: pgsql-general
On Tuesday 21 December 2004 21:21, Bruno Wolff III wrote:
> On Tue, Dec 21, 2004 at 20:47:31 +0000,
>
>   "Vladimir S. Petukhov" <vladimir(at)sycore(dot)org> wrote:
> > Ok, this is a real example:
> >
> > CREATE TABLE account (
> >   val1     BIGINT      NULL,
> >   val2    BIGINT      NULL,
> >  ...
> >
> >   daypos    SMALLINT    NULL,   -- Day position
> >   hourpos   SMALLINT    NULL,   -- Hour position
> >   id        INT         NULL  -- Link to the object
> > );
>
> That approach is reasonable but depending on what the val* columns mean
> you might each of those as a separate role. You didn't add a lot of
> information, but that they appear to be the same type suggests that you
> might want one row per value. But without knowing what they mean it is
> hard to say.

OK, i want to store ststistic information, ingoing/outgoing traffic, 
ingoing/outgoing errors(val1-val4) for example...

-- 
Man's unique agony as a species consists in his perpetual conflict between
the desire to stand out and the need to blend in.
		-- Sydney J. Harris

Now playing: (Воскресение) - Музыкант.mp3
   AutoGenerated by fortune & xmms...

In response to

Responses

pgsql-general by date

Next:From: Greg Sabino MullaneDate: 2004-12-22 01:05:43
Subject: ANNOUNCE: DBD::Pg 1.40 release candidate 1 request for testing
Previous:From: Paul TillotsonDate: 2004-12-22 00:09:39
Subject: tool for incrementally shrinking bloated tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group