postgres performance optimization

From: Kailash Vyas <kailash(dot)vyas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgres performance optimization
Date: 2005-07-26 15:42:32
Message-ID: a3cc791705072608425954e5a8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 = 128
shared_buffers = 1048576
sort_mem = 4096
random_page_cost = 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

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2005-07-26 15:47:13 Re: bien, esta es mi duda sobre almacenamiento de datos grandes en una columna
Previous Message Julio Rivero 2005-07-26 15:24:47 Re: bien, esta es mi duda sobre almacenamiento de datos grandes en una columna