News for hackers. Stuff that matters.

A comment on Ask HN: 120M rows Postgres – how can I speed up queries?.

Re:Ask HN: 120M rows Postgres – how can I speed up queries? by usgroup on Sunday November 10, 2019 @11:38AM (#21498693)
Use c_store fdw to store your data in columns and marvel at the 10x performance improvement without indexes.
[ Parent | on HN ]
Re:Ask HN: 120M rows Postgres – how can I speed up queries? by dbnewbie on Sunday November 10, 2019 @03:29PM (#21500005)
Excellent, thanks for the suggestion. I hadn’t heard of this lib until now. And, seeing that this is developed by Citus makes it automatically 10x better.
[ Parent | on HN ]