SQLIPPool performance issue

Peter Nixon listuser at peternixon.net
Thu Jul 26 16:53:04 CEST 2007


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/



More information about the Freeradius-Users mailing list