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(at)topconcepts(dot)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(dot)marlowe(at)ihs(dot)com>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "Justin Clift" <justin(at)postgresql(dot)org>; <pgsql-general(at)postgresql(dot)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.
>
>
>