X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A82CB52EA2 for ; Tue, 26 Jul 2005 12:42:55 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54590-06 for ; Tue, 26 Jul 2005 15:42:37 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.206]) by svr1.postgresql.org (Postfix) with ESMTP id 7C4FC52E98 for ; Tue, 26 Jul 2005 12:42:32 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 36so1161265wra for ; Tue, 26 Jul 2005 08:42:32 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type; b=B5zPws9na5FqhPIrQa9w1+mCbPuB0m1sKL4IQCpX20a68uA5VrHJ6BdXsfvEh4jtaH9u+bfh2mbSQUd2LQ6WvLe5akkI6HuoEoZdM2wFVvYzVd24h7KvmCJOz70G+Op5oojZ91G918tlZBiG8FHHa9hvQMXZ4ZnUvylwLbRwQBA= Received: by 10.54.119.20 with SMTP id r20mr167170wrc; Tue, 26 Jul 2005 08:42:32 -0700 (PDT) Received: by 10.54.129.3 with HTTP; Tue, 26 Jul 2005 08:42:32 -0700 (PDT) Message-ID: Date: Tue, 26 Jul 2005 16:42:32 +0100 From: Kailash Vyas Reply-To: Kailash Vyas To: pgsql-admin@postgresql.org Subject: postgres performance optimization Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_9557_4705177.1122392552798" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.221 tagged_above=0 required=5 tests=AWL, HTML_10_20, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/205 X-Sequence-Number: 18261 ------=_Part_9557_4705177.1122392552798 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi all, I have 1 gb ram on the server i am doing some performance tuning for postgres server. some of the configuration changes i have made are max_connections =3D 128=20 shared_buffers =3D 1048576 sort_mem =3D 4096 random_page_cost =3D 2 echo "1073741824" >/proc/sys/kernel/shmall echo "1073741824" >/proc/sys/kernel/shmmax are there any other configuration values which will affect the performance.= =20 Also what tool should i use for benchmarking purposes. thanks in advance, kailash ------=_Part_9557_4705177.1122392552798 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline hi all,

I have 1 gb ram on the server

i am doing some performance tuning for postgres server.
some of the configuration changes i have made are

max_connections =3D 128
shared_buffers =3D 1048576
sort_mem =3D 4096
random_page_cost =3D 2

echo "1073741824" >/proc/sys/kernel/shmall
echo "1073741824" >/proc/sys/kernel/shmmax

are there any other configuration values which will affect the performance. Also what tool should i use for benchmarking purposes.

thanks in advance,
kailash
------=_Part_9557_4705177.1122392552798--