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.
>
>
>
