Forum OpenACS Q&A: Re: Response to DB-Aolserver tuning and performance

Collapse
Posted by Iuri Sampaio on
How do i best setup aolserver and postgresql to my machine?

96Mb memoria ram, 4 gb hd, 30GB file transfer
linux debian3.1
postgresql 7.4
aolserver 4

I know the machine doesn't help too much. It's slow.
but even if had a better resources i would be aware to cleverly use them

I went through "/postgresql.conf"
https://openacs.org/doc/current/postgres.html#postgres-tune

and "/config.tcl" and set

#
# Server parameters
#
ns_section ns/server/${server}
ns_param maxconnections 100 ;# Max connections to put on queue
ns_param maxdropped 0
ns_param maxthreads 5
ns_param minthreads 1
ns_param threadtimeout 120 ;# Idle threads die at this rate