Hello pgsql-general, I have problem with my postgres server. I am running postgres 7.3.4 on RedHat9 (shrike) on dual processor machine. Sometimes (cca 3 times per day) postmaster service will freeze with 100% CPU load with SELECT statement (statement is never finished). If I try the same action again without restarting server, it works (but freezed postmasted still consume 100% CPU). It seems that something in postgres is locked, because if I run command vacuum when this situation happens, psql will freeze too. I defined also statement_timeout=600000 (10 minutes) in config, but It seem does not work.
Did somebody have the same problem? Please, help, this db is productive... -- Vladimir Drobny mailto:[EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
