On 02/02/2016 03:04 PM, Keith Brown wrote:
By reading this, http://www.postgresql.org/message-id/7e41ba8f0908191624g4501b5f7mcbe29ad2c8139acc@xxxxxxxxxxxxxx, 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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
