hello Micha, i think that noone can tell you much without more information about your system. roughly i would say that you could change the following parameters: shared_buffers = 1024MB -> 6GB work_mem = 256MB -> 30-50 MB effective_cache_size = 5120MB -> 16GB (depends on whether its a dedicated db server or not) kernel.shmmax=5368709120 : now its 5GB, probably you need more here, i would put 50% of ram kernel.shmall=5368709120 you need less here. check he shmsetup.sh script for more info autovacuum off -> on
-- View this message in context: http://postgresql.1045698.n5.nabble.com/Optimize-the-database-performance-tp4909314p4909422.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
