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.
[ Parent
| on HN ]
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!