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 4GB,

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

2013-03-30 Thread Ants Aasma
On Mar 28, 2013 9:07 PM, "kelphet xiong" wrote: > explain analyze select * from inventory; > QUERY PLAN > > -- > > Seq S

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 wrote: > 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 the system performa

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 serve