managing kernel

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: