X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 55CC353C92 for ; Sat, 5 Mar 2005 12:26:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25744-07 for ; Sat, 5 Mar 2005 12:26:37 +0000 (GMT) Received: from natpreptil.rzone.de (natpreptil.rzone.de [81.169.145.163]) by svr1.postgresql.org (Postfix) with ESMTP id 2ACD253C91 for ; Sat, 5 Mar 2005 12:26:36 +0000 (GMT) Received: from mainframe (pD4B9E93C.dip.t-dialin.net [212.185.233.60]) by post.webmailer.de (8.13.1/8.13.1) with SMTP id j25CQa7t005195 for ; Sat, 5 Mar 2005 13:26:37 +0100 (MET) Message-ID: <020301c5217e$94643c00$65a8a8c0@mainframe> From: "Michael Zoephel" To: Subject: performance problems Date: Sat, 5 Mar 2005 13:26:37 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0200_01C52186.F5973970" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200503/117 X-Sequence-Number: 10822 This is a multi-part message in MIME format. ------=_NextPart_000_0200_01C52186.F5973970 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, I have performance problems with the postmaster-process. The CPU usage = is permanently=20 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=F6phel e-Mail: zoephel@rechnerbetriebsgruppe.de ------=_NextPart_000_0200_01C52186.F5973970 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
I have performance problems with the=20 postmaster-process. The CPU usage is permanently 
around 90 %.
 
My DB:
 
    3,5 GB = Size
    largest table ca. = 700 000=20 rows
 
Most access:
 
    Finde a row - Update = if exist=20 Insert else
 
Average access:
 
    10 times a = second
 
    every Query needs = ca. 20=20 ms
 
 
All server options are still default=20 !!
 
Any idea on wich "screw" I can turn = ?.
 
 
Thanks for suggestions!
 
 
Michael Z=F6phel
 
e-Mail: zoephel@rechnerbetriebsg= ruppe.de
------=_NextPart_000_0200_01C52186.F5973970--