Re: Upgrade to dual processor machine?

hello,

Am I not allready using persistent connections with Pg.pm ?

It looks at least like it.... I only need a new connection
from webserver to db-server once a new webserver child is born.

well, anyway i am consindering updating to DBD::Pg of course...
it's only to change about 100.000 lines of perl code ....

> No, Justin is referring to the memory-related configuration options in
> postgresql.conf, like shared_buffers, wal_buffers, sort_mem, and the
> like.

so, how am i supposed to tune these settings ??

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(at)topconcepts(dot)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: "Neil Conway" <neilc(at)samurai(dot)com>
To: "Henrik Steffen" <steffen(at)city-map(dot)de>
Cc: "Justin Clift" <justin(at)postgresql(dot)org>; <pgsql-general(at)postgresql(dot)org>
Sent: Monday, November 11, 2002 8:32 AM
Subject: Re: [GENERAL] Upgrade to dual processor machine?

> "Henrik Steffen" <steffen(at)city-map(dot)de> writes:
> > > - What do the clients connect with? JDBC/ODBC/libpq/etc?
> > I am using Pg.pm --- this is called libpq, isn't it?
>
> Well, it's a thin Perl wrapper over libpq (which is the C client
> API). You said you're using mod_perl: you may wish to consider using
> DBI and DBD::Pg instead of Pg.pm, so you can make use of persistent
> connections using Apache::DBI.
>
> > > - 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
>
> No, Justin is referring to the memory-related configuration options in
> postgresql.conf, like shared_buffers, wal_buffers, sort_mem, and the
> like.
>
> > So, what do you suggest to gain more performance?
>
> IMHO, dual processors would likely be a good performance improvement.
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html