Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-13 Thread Jeff Bohmer
Just one more piece of advice, you might want to look into a good battery backed cache hardware RAID controller. They work quite well for heavily updated databases. The more drives you throw at the RAID array the faster it will be. I've seen this list often recommended such a setup. We'll

Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-13 Thread Jeff Bohmer
Shridhar Daithankar wrote: FWIW, there are only two pieces of software that need 64bit aware for a typical server job. Kernel and glibc. Rest of the apps can do fine as 32 bits unless you are oracle and insist on outsmarting OS. In fact running 32 bit apps on 64 bit OS has plenty of advantages

Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-12 Thread William Yu
Shridhar Daithankar wrote: FWIW, there are only two pieces of software that need 64bit aware for a typical server job. Kernel and glibc. Rest of the apps can do fine as 32 bits unless you are oracle and insist on outsmarting OS. In fact running 32 bit apps on 64 bit OS has plenty of advantages

Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-11 Thread William Yu
Jeff Bohmer wrote: We're willing to shell out extra bucks to get something that will undoubtedly handle the projected peak load in 12 months with excellent performance. But we're not familiar with PG's performance on Linux and don't like to waste money. Properly tuned, PG on Linux runs really

Re: [PERFORM] Hardware suggestions for Linux/PGSQL server

2003-12-11 Thread William Yu
Jeff Bohmer wrote: It seems I don't fully understand the bigmem situation. I've searched the archives, googled, checked RedHat's docs, etc. But I'm getting conflicting, incomplete and/or out of date information. Does anyone have pointers to bigmem info or configuration for the 2.4 kernel?