Re: storage of sensor data with Fourier transforms

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: nbinont(at)yahoo(dot)ca
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: storage of sensor data with Fourier transforms
Date: 2007-05-05 14:43:19
Message-ID: 19235.1178376199@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"Nathan Buchanan" <nbinont(at)gmail(dot)com> writes:
> I had the idea of taking the Fourier transform of the waveform and storing
> the waveform internally that way to reduce storage requirements.

Aside from what Steve said: The Fourier transform in itself doesn't
reduce data size --- it's N points in, N points out. If you want to
reduce storage requirements you have to resort to lossy compression, ie,
deliberately throwing away some data. The transformed data might be
more suitable for doing that (eg you can selectively discard
high-frequency components) but do you really want to? Usually the point
of storing measurements is so you can do unspecified analysis on them
later. Applying lossy compression will restrict what you can
(meaningfully) do later on.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2007-05-05 14:48:09 Re: Cache plan invalidation
Previous Message Bruce Momjian 2007-05-05 14:43:11 Cache plan invalidation