Postgres Performance ?

[Lukas Maly]

Dobry den

Provozuju jednu webovou aplikaci Request Tracker (
http://www.fsck.com/projects/rt/ )  ktera vyuziva postgresql-7.1.3 ve
spojeni mod_perl a apache. Celkove je rychlost uspokojiva. Jen u 3 akci,
ktere podle zdrojoveho koudu nedelaji nic co by melo databazi vytizit
zpusobi to ze dana akce trva dobrych 12-15 sec. coz je dost problem.
Samotna aplikace je vyvyjena pro MySQL, mozna jsem volil spatne, ale i tak
by me zajimalo zda nema nekdo podobny probem?

V dobe cekani 12 sec. nez se zobrazi v podstate jednoduchy formular se CPU
state pohybuje 94.6%

TOP:
last pid:  4743;  load averages:  0.28,  0.16,  0.13
up 0+17:01:24  11:41:30
63 processes:  3 running, 60 sleeping
CPU states: 94.6% user,  0.0% nice,  5.4% system,  0.0% interrupt,  0.0%
idle
Mem: 248M Active, 144M Inact, 81M Wired, 22M Cache, 61M Buf, 5232K Free
Swap: 200M Total, 200M Free

  PID USERNAME  PRI NICE  SIZE    RES STATE    TIME   WCPU    CPU COMMAND
  229 postgres   34   0  6104K  3660K RUN      1:14  9.08%  9.08% postgres
  241 postgres   34   0  6648K  3844K RUN      1:17  5.32%  5.32% postgres
  205 nobody      2   0 26600K 24468K select   0:32  3.96%  3.96% httpd


System bezi na

OS:
FreeBSD 4.6-STABLE-20020703-JPSNAP

CPU: Pentium III/Pentium III Xeon/Celeron (1007.39-MHz 686-class CPU)

RAM:
real memory  = 536805376 (524224K bytes)
avail memory = 516501504 (504396K bytes)

Dekuji za jakoukoliv radu ci nasmerovani na tuning :-)

S pozdravem

 Lukas Maly
 System Administrator

<!--
 Czech On Line, a.s.
 U nakladoveho nadrazi 8
 130 00  Praha 3
 Tel.: 420 (2) 460 00 435
 Fax.: 420 (2) 460 00 118
 www.jet2web.cz
 uin: 4126317
-->