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

Collapse
Posted by Don Baccus on
You need to figure out where the bottleneck is before you can start thinking about speeding it up.
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