Re: Upgrade to dual processor machine? - Mailing list pgsql-general

Hi Justin,

here a little more information:

> - Processor type and speed
Intel Pentium IV, 1.6 GHz

> - Memory
1024 MB ECC-RAM

> - Disk configuration
2 x 60 GB IDE (Raid 0)

> - OS
Redhat Linux

>
> - Do you do other stuff on it, apart from PostgreSQL?
No, it's a dedicated database server

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

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

So, what do you suggest to gain more performance?

Thanks in advance,

> Hi Henrik,
>
> It'd be helpful to know the other specifics of the server, and a bit
> about the workload the server has.
>
> i.e.
>
> - Processor type and speed
> - Memory
> - Disk configuration
> - OS
>
> - Do you do other stuff on it, apart from PostgreSQL?
>
> - How many clients simultaneously connecting to it?
> - What do the clients connect with?  JDBC/ODBC/libpq/etc?
>
> - Have you configured the memory after installation of PostgreSQL, so
> it's better optimised than the defaults?
>
> :-)
>
> Regards and best wishes,
>
> Justin Clift
>
>
> Henrik Steffen wrote:
> >
> > hi all,
> >
> > will an upgrade to a dual processor machine
> > noticeably increase performance of a postgresql server?
> >
> > load average now often is about 4.0 - 8.5 - and I'll
> > have got to do something sooner or later...
> >
> > any help is appreciated...
> >
> > --
> >
> > 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
> > --------------------------------------------------------
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> --
> "My grandfather once told me that there are two kinds of people: those
> who work and those who take the credit. He told me to try to be in the
> first group; there was less competition there."
>    - Indira Gandhi