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

Re: Howto Increased performace ?

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: <postuser(at)spr(dot)og(dot)th>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Howto Increased performace ?
Date: 2004-12-28 02:31:55
Message-ID: 006301c4ec85$68d372f0$7201a8c0@mst1x5r347kymb (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Hi Amrit,

I'm sorry to hear about the disaster in Thailand. I live in a tsunami prone 
area myself :-(

I think that you have enough information to solve your problem now, but it 
will just take some time and testing. When you have eliminated the excessive 
swapping and tuned your system as best you can, then you can decide if that 
is fast enough for you. More memory might help, but I can't say for sure. 
There are many other things to consider. I suggest that you spend some time 
reading through the performance and maybe the admin lists.


----- Original Message ----- 
From: "Amrit Angsusingh" <postuser(at)spr(dot)og(dot)th>
To: "Iain" <iain(at)mst(dot)co(dot)jp>
Cc: <pgsql-performance(at)postgresql(dot)org>
Sent: Tuesday, December 28, 2004 1:48 AM
Subject: Re: [PERFORM] Howto Increased performace ?

>> Hi,
>> These are some settings that I am planning to start with for a 4GB RAM
>> dual
>> opteron system with a maximum of 100 connections:
>> shared_buffers 8192 (=67MB RAM)
>> sort_mem 4096 (=400MB RAM for 100 connections)
>> effective_cache_size 380000(@8KB  =3.04GB RAM)
>> vacuum_mem 32768 KB
>> wal_buffers 64
>> checkpoint_segments 8
>> In theory, effective cache size is the amount of memory left over for the
>> OS
>> to cache the filesystem after running all programs and having 100 users
>> connected, plus a little slack.
>> regards
>> Iain
> I'm not sure if I put more RAM on my mechine ie: 6 GB . The performance
> would increase for more than 20 % ?
> Any comment please,
> Amrit Angsusingh
> Comcenter
> Sawanpracharuck Hospital
> Thailand

In response to

pgsql-performance by date

Next:From: IainDate: 2004-12-28 04:56:42
Subject: Re: Howto Increased performace ?
Previous:From: IainDate: 2004-12-28 02:23:41
Subject: Re: Howto Increased performace ?

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