Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group