Re: Upgrade to dual processor machine?
От | Henrik Steffen |
---|---|
Тема | Re: Upgrade to dual processor machine? |
Дата | |
Msg-id | 004801c28a81$8da1ca40$7100a8c0@STEINKAMP обсуждение исходный текст |
Ответ на | Re: Upgrade to dual processor machine? ("scott.marlowe" <scott.marlowe@ihs.com>) |
Список | pgsql-general |
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. > > >
В списке pgsql-general по дате отправления: