Re: Upgrade to dual processor machine?

The cache-field is saying 873548K cached at the moment
Is this a "whole bunch of cache" in your opinion? Is it too much?

So, where do i find and change shmmax shmall settings ??
What should I put there?

What is a recommended value for shared buffers in postgresql.conf ?


FYI:

ps ax | grep -c postgres ==> shows 23 at the moment

however, w shows: load average 3.09, 2.01, 1.76
(this is low at the moment)

thanks again,

--

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com          Tel. +49 4141 991230
mail: steffen@topconcepts.com       Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline:  +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
Ihr SMS-Gateway: JETZT NEU unter: http://sms.city-map.de
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

----- Original Message -----
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: "Henrik Steffen" <steffen@city-map.de>
Cc: "Justin Clift" <justin@postgresql.org>; <pgsql-general@postgresql.org>
Sent: Tuesday, November 12, 2002 6:22 PM
Subject: Re: [GENERAL] Upgrade to dual processor machine?


> On Mon, 11 Nov 2002, Henrik Steffen wrote:
>
> > > - How many clients simultaneously connecting to it?
> > one webserver with max. 50 instances, approximately 10.000 users a day,
> > about 150.000 Pageviews daily. All pages are created on the fly using
> > mod_perl connecting to the db-server.
>
> If you've got 50 simos, you could use more CPUs, whether your I/O bound or
> not.
>
> > > - What do the clients connect with?  JDBC/ODBC/libpq/etc?
> > I am using Pg.pm --- this is called libpq, isn't it?
> >
> > > - Have you configured the memory after installation of PostgreSQL, so
> > > it's better optimised than the defaults?
> > no - what should I do? Looking at 'top' right now, I see the following:
> > Mem 1020808K av, 1015840K used, 4968K free, 1356K shrd, 32852K buff
>
> Hey, what is the "cached" field saying there?  Is the machine caching a
> whole bunch or just a little?  If it's caching a whole bunch, look at
> increasing your shmmax shmall settings and then the shared buffers in
> postgresql.conf for better performance.
>
>
>