postgres performance optimization
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-admin@xxxxxxxxxxxxxx
- Subject: postgres performance optimization
- From: Kailash Vyas <kailash.vyas@xxxxxxxxx>
- Date: Tue, 26 Jul 2005 16:42:32 +0100
- 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=
- Reply-to: Kailash Vyas <kailash.vyas@xxxxxxxxx>
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
[Index of Archives]
[KVM ARM]
[KVM ia64]
[KVM ppc]
[Virtualization Tools]
[Spice Development]
[Libvirt]
[Libvirt Users]
[Linux USB Devel]
[Linux Audio Users]
[Yosemite Questions]
[Linux Kernel]
[Linux SCSI]
[XFree86]