Thread: performance problems

performance problems

From
"Michael Zoephel"
Date:
Hi,
 
I have performance problems with the postmaster-process. The CPU usage is permanently 
around 90 %.
 
My DB:
 
    3,5 GB Size
    largest table ca. 700 000 rows
 
Most access:
 
    Finde a row - Update if exist Insert else
 
Average access:
 
    10 times a second
 
    every Query needs ca. 20 ms
 
 
All server options are still default !!
 
Any idea on wich "screw" I can turn ?.
 
 
Thanks for suggestions!
 
 
Michael Zöphel