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
> 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
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
In response to
pgsql-performance by date
|Next:||From: Tom Lane||Date: 2009-07-28 01:40:36|
|Subject: Re: Will Postgres ever lock with read only queries? |
|Previous:||From: Mark Mielke||Date: 2009-07-28 01:02:08|
|Subject: Re: Will Postgres ever lock with read only queries?|