Chuck Swiger wrote: > On Oct 5, 2006, at 11:29 AM, Paul Lathrop wrote: >> That's really good to know. Unfortunately, nobody seems to have written >> down WHICH tunables need to be adjusted besides the one mentioned above, >> nor is there any information on what "reasonable value" means! >> >> Can anyone point me at a resource for more information on this? > > You're supposed to tune the appropriate values considering the workload > the machine is going to handle. "man tuning" has some additional > information, but without describing what kind of tasks you plan to do > with this machine with 14GB of RAM, nobody is going to be able to > provide you with really specific advice...
Good point. :-) I intend to deploy this system as a database server running Postgresql 8.1. The database is huge (30-40Gb) and can easily grow (it has gone as high as 100Gb). I expect as many as 1000 concurrent database connections now, and a potential need for scaling this up later. I'm aware of the SystemV memory tuning issues related to running Postgres on FreeBSD and I'll address those as soon as I can get the system to see the RAM. I tried just installing the stock PAE kernel, but the system still doesn't even acknowledge the RAM above 4Gb. Is this because I have not yet performed the tuning? Thanks for your help! --Paul
signature.asc
Description: OpenPGP digital signature