Will Postgres ever lock with read only queries?

Поиск
Список
Период
Сортировка
От Robert James
Тема Will Postgres ever lock with read only queries?
Дата
Msg-id e09785e00907271754w77ed3706kc6b469e6171cf271@mail.gmail.com
обсуждение исходный текст
Ответы Re: Will Postgres ever lock with read only queries?  (Mark Mielke <mark@mark.mielke.cc>)
Re: Will Postgres ever lock with read only queries?  (Chris <dmagick@gmail.com>)
Список pgsql-performance
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?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mike Ivanov
Дата:
Сообщение: Re: select query performance question
Следующее
От: Mark Mielke
Дата:
Сообщение: Re: Will Postgres ever lock with read only queries?