Ask HN: 120M rows Postgres – how can I speed up queries?

Re:Ask HN: 120M rows Postgres – how can I speed up queries? by ezekg on Thursday November 07, 2019 @05:55PM (#21478169)

Check out https://www.pgmustard.com/ if you haven't already. It has helped me optimize queries as much as possible when querying large datasets.

[ Parent | on HN ]

Re:Ask HN: 120M rows Postgres – how can I speed up queries? by dbnewbie on Thursday November 07, 2019 @06:49PM (#21478682)

Thanks! That’s awesome. I know roughly how to understand PG query plans, but it doesn’t ever seem to actually help me figure out a solution. This service looks like it will help quite a bit.

[ Parent | on HN ]