User Tools

Site Tools


postgresql
effective_io_concurrency = X

Can be raised for SSDs

for I in `/usr/bin/psql -d template1 -q -t -c "SELECT datname FROM pg_database WHERE datname NOT IN ('template0') ORDER BY datname;"`; do
        /usr/bin/pg_dump -F t ${I} | /usr/bin/lzop -1 > ${TEMPDIR}/${DATE}${I}.tar.lzo
done
max_connections = 300
shared_buffers = 80MB
postgresql.txt · Last modified: 2017/09/25 10:57 by Jan Forman