Search Postgresql Archives

Re: handling time series data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)



Take a look at cstore_fdw, it might be the best solution for you.

--
--
Josh Berkus
Red Hat OSAS
(any opinions are my own)


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux