Re: storage of sensor data with Fourier transforms - Mailing list pgsql-hackers

From Tom Lane
Subject Re: storage of sensor data with Fourier transforms
Date
Msg-id 19235.1178376199@sss.pgh.pa.us
Whole thread Raw
In response to storage of sensor data with Fourier transforms  ("Nathan Buchanan" <nbinont@gmail.com>)
Responses Re: storage of sensor data with Fourier transforms  ("Nathan Buchanan" <nbinont@gmail.com>)
List pgsql-hackers
"Nathan Buchanan" <nbinont@gmail.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


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Cache plan invalidation
Next
From: Bruce Momjian
Date:
Subject: Re: Cache plan invalidation