On Wed, 06 Sep 2006 14:02:56 -0400 Perrin Harkins <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> http://www.wiles.org ---------------------------------
