Postgres Pro
Downloads
Home   >   mailing lists

Re: Will Postgres ever lock with read only queries? - Mailing list pgsql-performance

From Mark Mielke
Subject Re: Will Postgres ever lock with read only queries?
Date
Msg-id 4A6E4E10.5000007@mark.mielke.cc
Whole thread Raw
In response to Will Postgres ever lock with read only queries?  (Robert James <srobertjames@gmail.com>)
List pgsql-performance
Tree view 
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@mielke.cc>

pgsql-performance by date:

Previous
From: Robert James
Date:
Subject: Will Postgres ever lock with read only queries?
Next
From: Chris
Date:
Subject: Re: Will Postgres ever lock with read only queries?