Re: DB and PostgreSQL on dual processor Mac OS X
| From: | culley harrelson | Date: | Wed, 04 Jun 2003 08:15:29 +0000 |
| Subject: | Re: DB and PostgreSQL on dual processor Mac OS X | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-5774@lists.php.net to get a copy of this message | ||
Maybe try setting:
log_statement = true
in your postgresql.conf file, monitor the log and see if queries are different.
culley
Greg Lane wrote:
Hello, I have a data warehouse application I've built with PHP 4.3 and PostgreSQL 7.3.2 running on Mac OS X 10.2.6 on a dual 1.42 Ghz G4. I've noticed a performance issue with my application when using PEAR DB 1.4. If I launch a complex select query (PHP page) from 3 different browser windows, I see 3 Postgres processes in Top. The first one uses >95% of one processor and the other two use 0%. When the first one finishes, the 2nd uses >95% of one processor and then when it completes, the third process finally gets a turn. If I do the same query in 3 different windows with phpPgAdmin, all 3 Postgres processes execute immediately with each immediately getting about 65% CPU. I've tried using both persistent and non-persistent connections. Does anyone have an idea what DB is doing differently than phpPgAdmin that might explain this behavior? Thanks, Greg