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.