Se da un sistem cu 2 procesoare PIII,
memorie destula si cu Red Hat 9 pe el.

# uname -r
2.4.20-18.9smp

# rpm -qa | grep -i postgresql
postgresql-server-7.3.4-1PGDG
postgresql-7.3.4-1PGDG
postgresql-libs-7.3.4-1PGDG


# netstat -n | grep ESTABLISHED | grep ':5432 ' | wc -l
     12

load average: 5.89, 4.70, 3.46
   


Procesele postmaster isi pierd majoritatea timpului
apeland functia sistem "semop" avand doar cateva conexiuni,
dupa cum se vede si mai jos, iar load average "zboara"
in sus. Urmarit cu strace vad apeluri sistem "normale",
apoi apar cateva zeci bune de apeluri "semop" si tot asa.
Vad ca google nu spune mai nimic. S-a mai lovit cineva
de problema asta?


          Thanks!


                               Vitalie

# strace -c -p PID
% time     seconds  usecs/call     calls    errors syscall
------ ----------- ----------- --------- --------- ----------------
 55.15    0.271690         140      1947           semop
 20.93    0.103118        1146        90           munmap
  8.43    0.041514        1297        32           recv
  5.26    0.025926         720        36           mremap
  2.73    0.013457         449        30           write
  2.18    0.010735        1193         9           read
  2.15    0.010594          74       144           brk
  1.34    0.006599         103        64           rt_sigaction
  0.67    0.003319         184        18         9 stat64
  0.57    0.002806          31        90           mmap2
  0.37    0.001833          57        32           send
  0.12    0.000609          12        52           _llseek
  0.04    0.000204           8        27           gettimeofday
  0.04    0.000173          10        18           time
  0.02    0.000074           8         9           rt_sigprocmask
------ ----------- ----------- --------- --------- ----------------
100.00    0.492651                  2598         9 total







--- 
Detalii despre listele noastre de mail: http://www.lug.ro/


Raspunde prin e-mail lui