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

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


> "Henrik Steffen" <steffen@city-map.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@samurai.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