Re: Now I am back, next thing. Final PGS tuning.

Scott, thank you.

I think I might have misunderstood the effective cache size. Its measured in 8kB blocks. So the old number 449697 equals 3.5 GB, which is quite much. Should I lower this? I had plans to use 2.75GB max. Can I put 2.75GB there? Should I leave it?


Also, Greg. Since I use Java, prepared statements are quite natural. And I read this part on the guide which I understand you are part of : 

http://www.postgresql.org/docs/current/static/runtime-config-resource.html#GUC-MAX-PREPARED-TRANSACTIONS

Should I change this value? Not sure... :S 

Worried about the locks... whats your though on this? Should I just leave it alone?


Sincerely / Jennifer