4 ms·
I have a +1tb Postgres database at home that has market data in it. Moving it over to another Postgres db that has timeseries extensions to compact and increase
by _boffin_ 3y ago
I have a +1tb Postgres database at home that has market data in it. Moving it over to another Postgres db that has timeseries extensions to compact and increase performance. Also thinking about just partitioning everything up into parquet files. Query performance isn’t the best and am currently trying to improve it.
- pcranaway 3y agoI know we're talking about postgres but have you looked at clickhouse? it seems pretty promising with big data (and also timeseries data with its log engines)
- cssanchez 3y agoCheck out Hydra for Postgres, its an extension to create columnar tables for data warehouse type of analytics. Disclaimer: I’m associated with them as they sell managed services, but the extension is open source.