Re: PAE tuning

2006-10-06 Thread Peter A. Giessel
On 2006/10/06 9:08, Paul Lathrop seems to have typed: > Is there a 64 > bit Intel distro I'm missing? I saw someone suggesting I use the AMD64 > version, but when I attempt to boot that from the install disk I get > some debugging output and a message saying "BTX halted" - I suspect that > me

Re: PAE tuning

2006-10-06 Thread Paul Lathrop
Paul Lathrop wrote: Chuck Swiger wrote: Oh, yes, one more thought-- your specific application, i.e. a large database, is one where running in 64-bit mode is highly likely to result in improved performance compared with running the OS in 32-bit mode. If you've got a AMD64 or EM64T capable CPU,

Re: PAE tuning

2006-10-06 Thread Paul Lathrop
Chuck Swiger wrote: Oh, yes, one more thought-- your specific application, i.e. a large database, is one where running in 64-bit mode is highly likely to result in improved performance compared with running the OS in 32-bit mode. If you've got a AMD64 or EM64T capable CPU, consider installing

Re: PAE tuning

2006-10-05 Thread Chuck Swiger
On Oct 5, 2006, at 12:34 PM, Paul Lathrop wrote: Many thanks for your advice. Well, you are most welcome. Is this information gleaned from experience or is there an information resource out there that I might utilize in the future when I deploy other applications? Yes, this information is g

Re: PAE tuning

2006-10-05 Thread Peter A. Giessel
On 2006/10/05 10:29, Paul Lathrop seems to have typed: > I just built a new Intel Xeon FreeBSD 6.1 server with 14Gb of RAM. I > started digging into PAE so that we could actually make use of the high > memory in this box The other thing you might consider is that if that Xeon system is 64bit (and

Re: PAE tuning

2006-10-05 Thread Paul Lathrop
Chuck Swiger wrote: > On Oct 5, 2006, at 12:13 PM, Paul Lathrop wrote: > You should tune the network stack settings towards LAN use (shorter > timeouts, larger send & receive buffers); you should probably tune down > the # of vnodes, adjust SysV shared memory as Postgres recommends: > Update your B

Re: PAE tuning

2006-10-05 Thread Richard Cotrina
Have you thought in using 6.1/amd64 instead of 6.1/i386 + PAE ? Your Xeon processor is supported under the amd64 port, using EM64T for addressing more than 4GB. I had some stability troubles in the past running mysql server with PAE enabled, for a 6GB RAM server. Regards On Thu, 5 Oct 2006, Pau

Re: PAE tuning

2006-10-05 Thread Chuck Swiger
On Oct 5, 2006, at 12:13 PM, Paul Lathrop wrote: 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). Oh, yes, one more thought-- your specific application, i.e. a large database, is o

Re: PAE tuning

2006-10-05 Thread Chuck Swiger
On Oct 5, 2006, at 12:13 PM, Paul Lathrop wrote: 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, no

Re: PAE tuning

2006-10-05 Thread Paul Lathrop
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 a

Re: PAE tuning

2006-10-05 Thread Chuck Swiger
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 f