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