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

Re: Will Postgres ever lock with read only queries?

From: Mark Mielke <mark(at)mark(dot)mielke(dot)cc>
To: Robert James <srobertjames(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Will Postgres ever lock with read only queries?
Date: 2009-07-28 01:02:08
Message-ID: 4A6E4E10.5000007@mark.mielke.cc (view raw or flat)
Thread:
Lists: pgsql-performance
On 07/27/2009 08:54 PM, Robert James wrote:
> Hi.  I'm seeing some weird behavior in Postgres.  I'm running read 
> only queries (SELECT that is - no UPDATE or DELETE or INSERT is 
> happening at all).  I can run one rather complicated query and the 
> results come back... eventually.  Likewise with another.  But, when I 
> run both queries at the same time, Postgres seems to ground to a halt. 
>  Neither one completes.  In fact, pgAdmin locks up - I need to cancel 
> them using psql.
> I'd expect this from MySQL but not Postgres.  Am I doing something 
> wrong? Or missing something?

I've never had straight queries block each other. What is the query? 
What version of PostgreSQL? What operating system?

Cheers,
mark

-- 
Mark Mielke<mark(at)mielke(dot)cc>


In response to

pgsql-performance by date

Next:From: ChrisDate: 2009-07-28 01:21:01
Subject: Re: Will Postgres ever lock with read only queries?
Previous:From: Robert JamesDate: 2009-07-28 00:54:05
Subject: Will Postgres ever lock with read only queries?

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