From: MirrorX <mirrorx@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Optimize the database performance
Date: Mon, 17 Oct 2011 03:39:26 -0700 (PDT)
Message-ID: <1318847966034-4909422.post@n5.nabble.com> (raw)
In-Reply-To: <CAF+MRtnRr_8QqZ5ZGz0_H8jzvn8KND=K7cVzX8aywiumN+UJwA@mail.gmail.com>
References: <CAF+MRtnRr_8QqZ5ZGz0_H8jzvn8KND=K7cVzX8aywiumN+UJwA@mail.gmail.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mirrorx@gmail.com
Subject: Re: Optimize the database performance
In-Reply-To: <1318847966034-4909422.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox