Re: [ADMIN] sql-statement blocks maschine

2006-05-23 Thread Adam Radlowski
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 ap

[ADMIN] sql-statement blocks maschine

2006-05-23 Thread MG
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 wh