Re: Upgrade to dual processor machine?

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