On Wed, 06 Sep 2006 14:02:56 -0400
Perrin Harkins wrote:

> You can usually increase your performance greatly just by tuning your
> existing SQL and database. Run Apache:Prof 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
http://www.wiles.org
---------------------------------