DB totaly in memory
DB totaly in memory
От:
"Gaetano Mendola" <mendola@bigfoot.com>
Дата:
Hi all, My database size is ~ 43M $> pwd /var/lib/pgsql/data/base $> du . -h 1.7M ./1 1.7M ./16555 39M ./220628 43M . the postgres is running with the parameter shared_buffers = 30400 So I'm using 256MB of shared memory. Now my question is, apparently all my entire database can be in memory, how should I set the others parameters to suggest that all my database is in memory? I'm wondering about in particular to the parameter: random_page_cost Some one have some suggestions ? Ciao Gaetano.