performance problems

From: "Michael Zoephel" <michel(at)edmi(dot)de>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: performance problems
Date: 2005-03-05 12:26:37
Message-ID: 020301c5217e$94643c00$65a8a8c0@mainframe
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

e-Mail: zoephel(at)rechnerbetriebsgruppe(dot)de

Browse pgsql-performance by date

  From Date Subject
Next Message mark.lubratt 2005-03-05 18:38:35 Query Optimization - Hash Join estimate off?
Previous Message Tom Lane 2005-03-05 04:33:42 Re: MAIN vs. PLAIN