Postgres Pro
Downloads
Home   >   mailing lists

performance problems - Mailing list pgsql-performance

From Michael Zoephel
Subject performance problems
Date
Msg-id 020301c5217e$94643c00$65a8a8c0@mainframe
Whole thread Raw
List pgsql-performance
Tree view
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
 

pgsql-performance by date:

Previous
From: "Dave Page"
Date:
Subject: Re: [pgsql-hackers-win32] Help with tuning this query (with
Next
From: John A Meinel
Date:
Subject: Re: [pgsql-hackers-win32] Help with tuning this query (with