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