Re:Ask HN: 120M rows Postgres – how can I speed up queries?
by lastofus on Thursday November 07, 2019 @04:57PM
(#21477745)
From my experience 7+ years ago, I saw an order of magnitude difference running Postgres on higher end bare metal hardware (think $6k rack mounted server w/ nice RAID controller) vs a supposed high end AWS VM w/ an EBS volume. That was testing with spinny disks before SSDs were the norm, but if you are on a cloud VM, it's probably worth investigating.
[ Parent
| on HN ]
Re:Ask HN: 120M rows Postgres – how can I speed up queries?
by dbnewbie on Thursday November 07, 2019 @06:48PM
(#21478675)
Thank you for the suggestion. I don’t know for certain that it’s a tenable solution, because we are using some services that would take some time to vertically integrated if we were to go to a colo. But when we reach that scale that will definitely be an effort worth exploring.