| From: | "MG" <pgsql-admin(at)carladata(dot)de> |
|---|---|
| To: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | sql-statement blocks maschine |
| Date: | 2006-05-23 08:39:24 |
| Message-ID: | 001301c67e44$6526df00$340aa8c0@geisslinger |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hello,
we are using PostgreSQL 8.0.3 under SuSE Linux 9.2 and SCO OpenServer 6.0 and have some perfomance problems. We are working with telnet-clients, which controlls our application on the server. The application does the sql-statements
If we have sql-statements e.g. SELECT or UPDATE which takes some minutes to be executed, then this statement blocks the whole maschine. This has the affect, that the telnet-clients work very very slowly, e.g. it takes several seconds from one keystroke to the next one. So you can`t work with the application in a reasonable way.
These sql-statments are so variable, that we can`t create a index for each combination.
How can we solve that problem?
Greeting
Michaela
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kouber Saparev | 2006-05-23 10:53:50 | Re: Updatable view and default sequence values |
| Previous Message | Hakan Kocaman | 2006-05-23 08:14:27 | Re: defining Your own sort order for already compiled PostgreSQL (because PSQL sort orders are incopatible with ASCII sort order for non -alpha characters) |