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. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
