Re:Show HN: Database Labs – Postgres as a Service
by thu on Monday October 20, 2014 @02:24PM
(#8483680)
I would love to learn what you would expect from a PostgreSQL as a Service offer that would cost $0.50/month on top of DO.
Having about 10,000 customers at that price point asking "quick general question" to gain a ridiculous salary ?
Re:Show HN: Database Labs – Postgres as a Service
by icot on Monday October 20, 2014 @01:02PM
(#8483178)
If the whole database is 2GB, can you get a server big enough to have all your data in memory, or at least the hot part of your data? That would be better.
Re:Show HN: Database Labs – Postgres as a Service
by __xtrimsky on Monday October 20, 2014 @01:25PM
(#8483300)
It looks like a safe method is to make the innodb_buffer_pool_size a lot bigger, and it will in fact store all the db in memory.
(Otherwise you need to set up a backup or a replication in case the server goes down)
I'll play around with it, thanks!
I don't know if that would attract someone, it doesn't work for me. Not enough features for twice the price. I would advice only a small increase (+10% or so).
Quick general question:
I have a server in Montreal. My server hosting doesn't have SSDs for cheap. For a semi-big database (2gb), is it better for me to get a DigitalOcean with SSD in New York? Would that improve my database, or will the ping slow it down too much. (in my example the ping would be of about 23ms)