Bug #2157
closedMetacat Performance: Optimize Postgres and Tomcat...
0%
Description
There might be some options in Tomcat to speed things up a little bit. e.g.
Chris suggested about turning off autoloading of war files.
In Postgres.. From Matt's email...
It would be best to fit the whole postgres
image into memory so it need not be swapped to disk for queries.
Postgres needs to be configured to use the memory even if its on the
machine. Chris saw significant performance gains by upping the memory
for Postgres to 768MB. We have a much larger DB, so we probably want to
go higher. Ecoinfo2 has 2GB of RAM, which we should probably increase
to 4GB. New machines should have that much at least, but we run into
the 32bit limit so might need to consider moving to a 64bit os. Sid
should look at the memory size needed for the postgres image on ecoinfo2
to get an idea of how much we need.
Related issues