Ask HN: Largest Postgres DBs?

Re:Ask HN: Largest Postgres DBs? by _boffin_ on Tuesday May 30, 2023 @09:44AM (#36124812)

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.

[ Parent | on HN ]

Re:Ask HN: Largest Postgres DBs? by pcranaway on Tuesday May 30, 2023 @11:50AM (#36126277)

I 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)

[ Parent | on HN ]

Re:Ask HN: Largest Postgres DBs? by cssanchez on Tuesday May 30, 2023 @12:16PM (#36126652)

Check 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.

[ Parent | on HN ]