Robert James wrote:
Thanks for the replies. I'm running Postgres 8.2 on Windows XP, Intel
Core Duo (though Postgres seems to use only one 1 core).
A single query can only use one core, but it will use both if multiple
queries come in.
The queries are self joins on very large tables, with l
Can you run those two queries with psql?
I remember having some trouble running multiple queries in the same pgadmin
process. Both would get stuck until both finished I think. I went to
running a pgadmin process per query.
On Tue, Jul 28, 2009 at 9:17 AM, Robert James wrote:
> Thanks for the r
Thanks for the replies. I'm running Postgres 8.2 on Windows XP, Intel Core
Duo (though Postgres seems to use only one 1 core).
The queries are self joins on very large tables, with lots of nested loops.
On Mon, Jul 27, 2009 at 9:40 PM, Tom Lane wrote:
> Chris writes:
> > Robert James wrote:
>
Chris writes:
> 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 a
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 bot
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 anoth
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 ti