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.
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 |