Iñigo Martinez Lasala wrote: >> Hi All, I have a database of 10GB. My Database Server has a >> RAM of 16GB Is there a way that I can load all the database >> objects to memory? Thanks for your time and taking a look >> at this question. Thanks Deepak > > Increase effective_cache_size parameter. > > An "effective_cache_size=11GB" should be more than enough.
Sorry, but that is quite wrong. effective_cache_size only affects the planner, not memory utilization. You can use shared_buffers=11GB to give PostgreSQL memory enough to buffer all of a 10GB database in memory. But that does not automatically put all the tables in memory. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
