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

From Chris
Subject Re: Will Postgres ever lock with read only queries?
Date
Msg-id 4A6E527D.2070304@gmail.com
Whole thread Raw
In response to Will Postgres ever lock with read only queries?  (Robert James <srobertjames@gmail.com>)
Responses Re: Will Postgres ever lock with read only queries?
List pgsql-performance
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?

They're probably not blocking each other but more likely you're
exhausting your servers resources. If they return "eventually"
individually, then running both at the same time will take at least
"eventually x2".

As Mark said, what are the queries? What postgres version? What o/s?
What are your hardware specs (how much memory, disk speeds/types etc)?

--
Postgresql & php tutorials
http://www.designmagick.com/


pgsql-performance by date:

Previous
From: Mark Mielke
Date:
Subject: Re: Will Postgres ever lock with read only queries?
Next
From: Tom Lane
Date:
Subject: Re: Will Postgres ever lock with read only queries?