| From: | Kimi <kimi(at)intercept(dot)co(dot)in> |
|---|---|
| To: | pgsql-general(at)postgreSQL(dot)org, scrappy(at)hub(dot)org |
| Subject: | Postgres performance problems. |
| Date: | 1999-12-22 13:49:30 |
| Message-ID: | 3.0.5.32.19991222184930.00808700@10.10.10.4 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
We have developed an application using PG 6.5.1, DBI-1.13 and DBD-0.92 with
perl5.
We have a small db with a query with 5 joins and other smaller singleton
selects.
Now this query will be executed about 50 times a second.
While doing a load test to find performance we find that for 100 parallel
perl requests
only around 10 postgres processes get executed.
Why is this so. Is there anyway to configure and increase this. -N and -B
parameters in
postmaster don't seem to help.
Thanks in Advance,
Murali
Differentiated Software Solutions
____________________________________________________________________________
K.P.Krishnan Phones:+91-44-4349882
Client Understanding +91-44-4349469
Intercept Consulting India (P) Ltd Fax: +91-44-4349842
Chennai Mobile 9841064540
India email: krishnan(at)intercept(dot)co(dot)in
____________________________________________________________________________
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mike Beller | 1999-12-22 14:55:56 | Re: [GENERAL] copy command -- foiled by pg_atoi |
| Previous Message | David Warnock | 1999-12-22 13:10:34 | Interbase replacement |