News for hackers. Stuff that matters.
Re:Your data fits in RAM by mhaymo on Thursday May 21, 2015 @10:44AM (#9583029)
Does your RDBMS's built-in caching not handle this pretty well? Just up the cache size, e.g. in PostgreSQL changing effective_cache_size https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...
Re:Your data fits in RAM by SwellJoe on Thursday May 21, 2015 @10:48AM (#9583048)
For reads, yes. It's fine on reading data. The problems are writes which always wait for disk consistency to return.
Re:Your data fits in RAM by nierman on Thursday May 21, 2015 @10:26PM (#9586363)
shared_buffers is the setting you're thinking of here.

effective_cache_size should be set to a reasonable value of course, but it does not affect the allocated cache size, it's just used by the query optimizer.