Re: [PERFORM] Postgresql performance degrading... how to diagnose the root cause

2013-03-30 Thread Cédric Villemain
I don't know that tcp-b does tpcb.jar is a java implementation of the http://www.tpc.org/tpcb/ benchmark. It is not particularly representative of my workload, but gives a synthetic, db-agnostic, view of the system performance. We use it to have quick view to compare differents servers

Re: [PERFORM] Postgresql performance degrading... how to diagnose the root cause

2013-03-30 Thread Jeff Janes
On Fri, Mar 29, 2013 at 8:31 AM, Franck Routier franck.rout...@axege.comwrote: Hi, I don't know that tcp-b does tpcb.jar is a java implementation of the http://www.tpc.org/tpcb/benchmark. It is not particularly representative of my workload, but gives a synthetic, db-agnostic, view of

Re: [PERFORM] Question about postmaster's CPU usage

2013-03-30 Thread Ants Aasma
On Mar 28, 2013 9:07 PM, kelphet xiong kelp...@gmail.com wrote: explain analyze select * from inventory; QUERY PLAN --

Re: [PERFORM] Question about postmaster's CPU usage

2013-03-30 Thread Kelphet Xiong
Thanks a lot for replies from Kevin, Ken, and Ants Aasma. I really aappreciate your suggestions and comments. My server configuration is two physical quad-core CPUs with hyper-threading enabled. Each CPU is Intel(R) Xeon(R) CPU E5620@2.40GHz. Physical memory is 16GB. I set shared_buffers as