| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris | 2009-07-28 01:21:01 | Re: Will Postgres ever lock with read only queries? |
| Previous Message | Robert James | 2009-07-28 00:54:05 | Will Postgres ever lock with read only queries? |