perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Frank Wiles <fr...@wiles.org>
Subject Re: mod_perl reqs/s @ concurrency-- for actual db based applications
Date Wed, 06 Sep 2006 21:33:27 GMT
On Wed, 06 Sep 2006 14:02:56 -0400
Perrin Harkins <perrin@elem.com> wrote:

> You can usually increase your performance greatly just by tuning your
> existing SQL and database.  Run Apache::DProf or the DBI profiler,
> find out where the time is being spent, and work on it.  There are
> many resources for database performance tuning.  Work on the actual
> queries and schema structure, not on the database configuration.  You
> always get more from the former than the latter.

   Agree with everything else you said, but have to disagree with the
   last statement.  Specifically with PostgreSQL the default server
   configuration is a really low end config, setup to basically run
   on any old hardware you have around. 

   Configuring it for your particular hardware ( memory size
   specifically ) can reap HUGE performance gains. In case anyone
   is wondering the two most useful tweaks are shared_buffers
   and effective_cache_size which need to be increased on all but
   the lowliest of systems. 

   PostgreSQL may be the only one where this is true however... 

 ---------------------------------
   Frank Wiles <frank@wiles.org>
   http://www.wiles.org
 ---------------------------------


Mime
View raw message