News for hackers. Stuff that matters.

A comment on Lessons learned scaling a PostgreSQL database to 1.2bn records/month. Parent comment

Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by Shish2k on Tuesday January 29, 2019 @11:18AM (#19027521)
FWIW I'm in a similar situation, running a moderately sized site (10 servers, ~2gbps) on leaseweb hosts, costing ~$1,500/mo - every year or so I look at cloud offerings, and see that the bandwidth alone would be something like $40,000/mo.

I also have ~10 smaller hobby projects (<100 monthly active users) which could easily fit inside the smallest cloud services, but the smallest on offer seems to be $5/mo, so $50/mo in total. For $25/mo I can get a pair of bare metal servers which host all of them with failover and a ton of capacity to spare.

Then my actual day-job is at the opposite end of the scale, where we build our own datacenters...

I am very confused by the movement towards using the cloud for everything, because I work at all sorts of scales, and can't find a cloud host who works well for any of my use-cases :S

[ Parent | on HN ]
Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by jsty on Tuesday January 29, 2019 @12:04PM (#19027899)
> I am very confused by the movement towards using the cloud for everything, because I work at all sorts of scales, and can't find a cloud host who works well for any of my use-cases

Just a couple off the top of my head:

1 - Incredibly large infrequently run / ad-hoc workloads

2 - Companies with such a horrendous internal work environment that they can't retain decent technical talent, where managed services can substitute to some degree.

[ Parent | on HN ]
Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by foggyToads on Thursday January 31, 2019 @12:40PM (#19046729)
Do you mind if I ask what service you're using to host your hobby projects?
[ Parent | on HN ]
Re:Lessons learned scaling a PostgreSQL database to 1.2bn re... by Shish2k on Friday February 01, 2019 @06:28AM (#19053291)
Kimsufi - AFAIK they get their low prices by using second-hand hardware, but I've not found that to be an issue (hard drive failures are a little more common than the leaseweb servers, but "more common" is still only "one failure per server per 5 years" - and that's easily mitigated by setting up a pair of servers with failover)
[ Parent | on HN ]