On 02/02/2016 03:04 PM, Keith Brown wrote:
By reading this,
http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139...@mail.gmail.com,
I was wondering if anything has changed on the postgresql front.
I have a large timeseries (2TB worth of uncompressed data). I will be
doing some queries which change at times. Should I stick with my
current approach which is a series of csv files or would it be better
to load it into Postgresql and use its TOAST features (which will give
me some sort of compression)
TOAST does not cover all data types, so you might not get the
compression you think:
http://www.postgresql.org/docs/9.5/static/storage-toast.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
