Running 2 select statements concurrently

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Running 2 select statements concurrently

Postby jockodundee » Sat Apr 11, 2009 3:20 pm

Is it strange that when I run multiple select statements concurrently, each statement has to wait until the first one finishes.
For instance, if I start a query that takes 10 minutes, then I start a query that should run instantly, the instant query wont finish until the 10 minute query does.
jockodundee
 
Posts: 23
Joined: Tue Feb 05, 2008 3:42 pm

Re: Running 2 select statements concurrently

Postby WhiteRider » Sun Apr 12, 2009 3:48 am

Are you doing this in PGAdmin?
As I understand it, postgres isn't multi-threaded so won't do two things concurrently.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin