Thread: sql-statement blocks maschine

sql-statement blocks maschine

From
"MG"
Date:
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

Re: sql-statement blocks maschine

From
Adam Radlowski
Date:
Run the "top" program. You'll see, that Your server CPU time is strongly
take by postmaster. The best way is to have two machines - servers: for
database server and for terminals. Maybe good will be to have more than
one CPU in the one server and run database server on CPU not used by
others apps.
Greetins
Adam

MG wrote:

> 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