The following bug has been logged online: Bug reference: 5229 Logged by: Fredrik Palm Email address: fredrik.p...@humlab.umu.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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
