From: | bubba postgres <bubba(dot)postgres(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Time Series on Postgres (HOWTO?) |
Date: | 2011-01-15 00:41:07 |
Message-ID: | AANLkTik5JQiydiuqSt7h82JH1ix4zG5dZ42Y-v=AxZOL@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I've been googling, but haven't found a good answer to what I should do if I
want to store time series in Postgres.
My current solution is store serialized (compressed) blobs of data.
(So for example store 1 day worth of 1 minute samples (~1440 samples) stored
as one row in a bytea. (Plus meta data)
It would be nice if I could use 1 sample per column,(because updating
individual columns/samples is clear to me) but postgres doesn't compress the
row (which is bad because of high amount of repetitive data.. Easily 10X
bigger.
I've been considering a Double[] array, which would get compressed, but
before I start down that path (I suppose I need to make some storedprocs to
update individual samples), has anyone built anything like this? Any open
source projects I should look at?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Whit Armstrong | 2011-01-15 00:49:09 | Re: Time Series on Postgres (HOWTO?) |
Previous Message | Gunnar Wolf | 2011-01-15 00:07:36 | Re: Oferta de un nuevo Entrenamiento en el marco del Tercer PGDay Latinoamericano. |