how many ram is consuming the nsd process?
41% = 1.8 GB
shared_buffers = 65636
sort_mem = 32168
What is the shmax according to these figures?
You're running vacuum analyze at least once a day, right?
once every 24h
pg_autovacuum is as well very good option.
Where do I configure that?
Are your CR files stored in the file system?
yes
One way to achieve that is to put ALL your static files (images, css, etc) into the resources folder of each >package, and then put them into your static site
already done
add a rule into pound to redirect
already done
Next step will be to have a cluster.
like several dynamic server connected to one database?
How many concurrent connections do you have at peak times?
Try this in your dinamic system:
while [ 1 ]; do echo -n `date` >> tcp_report.txt; echo -n ' | ' >> tcp_report.txt; lsof | grep 8000 | grep TCP | grep -v LISTEN | wc -l >> tcp_report.txt; done;
(thanks to Derick)
Also look for blocked processes in PG (something that is >waiting or blocked for too long sometimes reduces the >performance, you can kill it). ps axuf
how can I kill a blocked postgresql process securely?
