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
