On Thu 26 Jul 2007, Kenneth Marshall wrote: > Roy, > > It sounds like you may need to adjust the DB parameters. The defaults, > even in 8.2, are still fairly conservative. Would you post your current > settings for things like: > > max_connections > shared_buffers > work_mem > maintenance_work_mem > max_fsm_pages > vacuum_cost_* > bgwriter_* > wal_buffers > commit_delay > commit_siblings > checkpoint_segments > checkpoint_timeout > random_page_cost > effective_cache_size > autovacuum > autovacuum_* > > Basically, anything you have changed from the default configuration > file. Proper choices for these parameters can make a huge difference > in baseline performance.
Yep. My guess is, on that box, if he is running a default Postgresql config he should get 10-100 times greater performance after tuning it correctly for the ram and cpu setup.. Cheers -- Peter Nixon http://peternixon.net/ - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
