BUG #5229: Queing requests when not using psql

From: "Fredrik Palm" <fredrik(dot)palm(at)humlab(dot)umu(dot)se>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5229: Queing requests when not using psql
Date: 2009-12-03 11:16:02
Message-ID: 200912031116.nB3BG2fV083673@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5229
Logged by: Fredrik Palm
Email address: fredrik(dot)palm(at)humlab(dot)umu(dot)se
PostgreSQL version: 8.3 & 8,4
Operating system: Vista 64
Description: Queing requests when not using psql
Details:

I am using a standard default installation of postgres.
it being set up to accept connections from other servers.

When using multiple psql-client to access the database server from another
machine the query (select * from table)
retrieves the content with linear performance according to how many core I
have (8)

A) When repeating the same thing with for example multiple and different
php-request from one apache/phpthe queries are bein queeed and executed in
order and does not use any extra processers avaiable

B) The same happen if I create multiple connections using PGadmin on the
same client(multple instances as well as multiple connections)

C) If I use different PHP-server accessing the database server, than the
postgres database is using the CPU that exists.

I think the multiple connection from the same client machine should be able
to use different threads on the database-server also for other clients the
pgsql.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message aftab 2009-12-03 12:07:38 BUG #5230: Limit operator slows down
Previous Message Heikki Linnakangas 2009-12-03 11:08:31 Re: Assertion failure with a subtransaction and cursor