Thread: managing kernel
My sysadmin has changed the values for shmall to 256MB (268435456) and shmmax to 1GB (1073741824) and I wonder if these values seem ok to you. We are working on a linux system (2.4 kernel) and have 2 GB RAM at our disposal. I have this large database running (15 million records). Are there any other parameters I should/could tweak for better performance? Best Regards Dino __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail
OK, I have RTFM:-) SHMALL Total amount of shared memory available (bytes or pages) if bytes, same as SHMMAX; if pages, ceil(SHMMAX/PAGE_SIZE) These values should be the same. I've changed that now. Still my second question is valid though. Are there any other values I should consider changing in order to boost performance. I'm using postgresql 7.4. Brgds Dino --- Dino Vliet <dino_vliet@yahoo.com> wrote: > My sysadmin has changed the values for shmall to > 256MB > (268435456) and shmmax to 1GB (1073741824) and I > wonder if these values seem ok to you. We are > working > on a linux system (2.4 kernel) and have 2 GB RAM at > our disposal. I have this large database running (15 > million records). > > Are there any other parameters I should/could tweak > for better performance? > > Best Regards > Dino > > > > __________________________________ > Do you Yahoo!? > Yahoo! Mail - Helps protect you from nasty viruses. > http://promotions.yahoo.com/new_mail > > ---------------------------(end of > broadcast)--------------------------- > TIP 8: explain analyze is your friend > __________________________________ Do you Yahoo!? Plan great trips with Yahoo! Travel: Now over 17,000 guides! http://travel.yahoo.com/p-travelguide
You'll probably want to take a look at this performance tuning reference: http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html and this annotated configuration file: http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Apr 17, 2005, at 4:57 AM, Dino Vliet wrote: > OK, > I have RTFM:-) > SHMALL Total amount of shared memory available (bytes > or pages) if bytes, same as SHMMAX; if pages, > ceil(SHMMAX/PAGE_SIZE) > > These values should be the same. I've changed that > now. > > Still my second question is valid though. Are there > any other values I should consider changing in order > to boost performance. > I'm using postgresql 7.4. > > Brgds > Dino