RE: Performance tuning for linux, 1GB RAM, dual CPU? - Mailing list pgsql-general

Sure, here it comes.

/Buckis

-----Original Message-----
From: Adam Manock [mailto:abmanock@planetcable.net]
Sent: den 11 juli 2001 16:26
To: Christian Bucanac
Subject: RE: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?


We should move this discussion back to the list... others may benefit.
If you're agreeable please forward your previous message to the list.

Adam


At 03:02 PM 7/11/01 +0200, you wrote:
>Yes, that is right. We did
>echo 805306368 >/proc/sys/kernel/shmax
>
>805306368 => 768MB
>
>We could not allocate 98304 buffers as you suggest, 96498 was the maximum.
>Seems like postmaster/postgres uses some mem for other things.
>
>/Buckis
>
>
>
>-----Original Message-----
>From: Adam Manock [mailto:abmanock@planetcable.net]
>Sent: den 11 juli 2001 14:10
>To: Christian Bucanac
>Subject: RE: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?
>
>
>I assume you had to bump up the shmmax and shmall
>as mentioned in:
>
>http://www.ca.postgresql.org/docs/admin/kernel-resources.html
>
>Your parameters look good, close to what I am thinking
>I am going to try 768M (98304) for buffers and 6144 (6144 * 32 = 192M)
>for sort mem. This way with the DB server serving a max of 32 application
>servers the kernel and other processes should still have the last 64Mb RAM.
>This will be my starting point for testing anyway.
>
>Adam
>
>
>Adam
>
>At 10:00 AM 7/11/01 +0200, you wrote:
> >Hi!
> >
> >We have setup a Pentium III with dual 900MHz processors computer with
>RAIDed
> >disks. It is running Slackware because it is the most reliable
>distribution.
> >We have compiled and are using kernel 2.4.2 to better support dual
> >processors. The RAM is 1GB. The only perfomance tuning we have done is to
> >let the postmaster/postgres allocate as much RAM as possible. The shared
> >buffers (-B option) is set to 96498 which is about 800MB of RAM and the
>sort
> >mem size (-S) is set to 5120. The sort mem size is set this low because
> >there can be many connections to the database.
> >
> >These optimizations are enough for out environment and usage of the
>database
> >so we have not bothered to optimize it further. The database is
practically
> >running in RAM.
> >
> >/Buckis
> >
> >
> >-----Original Message-----
> >From: Adam Manock [mailto:abmanock@planetcable.net]
> >Sent: den 10 juli 2001 13:45
> >To: pgsql-general@postgresql.org
> >Subject: [GENERAL] Performance tuning for linux, 1GB RAM, dual CPU?
> >
> >
> >Hi,
> >
> >I am about to put a 7.1.2 server into production on RedHat 7.1
> >The server will be dedicated to PostgreSQL, running a bare minimum of
> >additional services.
> >If anyone has already tuned the configurable parameters on a dual PIII w/
> >1GB RAM then I
> >will have a great place to start for my performance tuning!
> >When I'm done I'll be posting my results here for the next first timer
that
> >comes along.
> >
> >Thanks in advance,
> >
> >Adam
> >
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 6: Have you searched our list archives?
> >
> >http://www.postgresql.org/search.mpl