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@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
