Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL

2006-07-20 Thread Tom Lane
Tatsuo Ishii <[EMAIL PROTECTED]> writes: >>> 18% in s_lock is definitely bad :-(. Were you able to determine which >>> LWLock(s) are accounting for the contention? > Sorry for the delay. Finally I got the oprofile data. It's > huge(34MB). If you are interested, I can put somewhere. Please let me

Re: [PERFORM] Performance penalty for remote access of postgresql

2006-07-20 Thread David Boreham
Guoping Zhang wrote: a) SERVER A to SERVER B: 0.35ms SERVER A to itself (Local host): 0.022ms 0.35ms seems rather slow. You might try investigating what's in the path. For comparison, between two machines here (three GigE switches in the path), I see 0.10ms RTT. Between two machines on