Re: [GENERAL] [NOVICE] Fwd: Process scheduling in postgres

2016-04-27 Thread John R Pierce
On 4/25/2016 12:40 AM, raghu vineel wrote: Yes, they query the same table. But all queries are *select* only. Postgres is 8.3 and OS is *LINUX 2.6.32-431.el6.x86_64. * Also I could see that pg_locks.granted is true for the queries I have submitted and lock mode is*AccessShareLock.* select *

Re: [GENERAL] [NOVICE] Fwd: Process scheduling in postgres

2016-04-27 Thread raghu vineel
On Sat, Apr 23, 2016 at 11:21 AM, Sameer Kumar wrote: > > > On Fri, Apr 22, 2016 at 5:21 PM raghu vineel > wrote: > >> >> Hi, >> >> I have a 4 core CPU for postgres and I have submitted 6 queries parallely >> in 6 different sessions. But I am seeing only 1 query per CPU and the >> remainig queri

Re: [GENERAL] [NOVICE] Fwd: Process scheduling in postgres

2016-04-22 Thread Sameer Kumar
On Fri, Apr 22, 2016 at 5:21 PM raghu vineel wrote: > > Hi, > > I have a 4 core CPU for postgres and I have submitted 6 queries parallely > in 6 different sessions. But I am seeing only 1 query per CPU and the > remainig queries are queued. I am not sure why is it happening. Do you have > any spe