X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 0FD85D1C4C8 for ; Wed, 13 Aug 2003 14:04:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 16330-10 for ; Wed, 13 Aug 2003 11:03:04 -0300 (ADT) Received: from correo (correo.qoslabs.com [157.238.87.78]) by svr1.postgresql.org (Postfix) with ESMTP id AC7F9D1C4B8 for ; Wed, 13 Aug 2003 11:04:21 -0300 (ADT) Received: from ldap-02.qoslabs.com (ldap-02 [172.20.1.31]) by correo-01.qoslabs.com (iPlanet Messaging Server 5.2 Patch 1 (built Aug 19 2002)) with SMTP id <0HJK007NA9RARH@correo-01.qoslabs.com> for pgsql-performance@postgresql.org; Wed, 13 Aug 2003 10:04:22 -0400 (EDT) Received: (from ingridmartinez [148.233.235.189]) by ldap-02.qoslabs.com (NAVGW 2.5.2.12) with SMTP id M2003081310042003352 for ; Wed, 13 Aug 2003 10:04:20 -0400 Date: Wed, 13 Aug 2003 09:03:31 -0500 From: ingrid martinez Subject: How can I Improve performance in Solaris? To: pgsql-performance@postgresql.org Message-id: <001f01c361a3$ae2c7ae0$8e64a8c0@ingridmartinez> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Mailer: Microsoft Outlook Express 6.00.2800.1158 Content-type: multipart/alternative; boundary="Boundary_(ID_YgqVKM6e27aF0YmARNpKMw)" X-Priority: 3 X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_60_70 X-Spam-Level: X-Archive-Number: 200308/233 X-Sequence-Number: 3050 This is a multi-part message in MIME format. --Boundary_(ID_YgqVKM6e27aF0YmARNpKMw) Content-type: text/plain; charset=iso-8859-1 Content-transfer-encoding: 7BIT I want to know, how can I improve the performance of postgres, I have a java class thar inserts register every 30 min but is very slow. The process of postgres consume the 78% of CPU. I have in /etc/system set shmsys:shminfo_shmmax=0x50000000 set shmsys:shminfo_shmmni=0x100 set shmsys:shminfo_shmseg=0x10 Thanks Ingrid --Boundary_(ID_YgqVKM6e27aF0YmARNpKMw) Content-type: text/html; charset=iso-8859-1 Content-transfer-encoding: 7BIT
I want to know, how can I improve the performance of postgres, I have a java class thar inserts register every 30 min but is very slow.
The process of postgres consume the 78% of CPU.
 
I have in /etc/system
 

set shmsys:shminfo_shmmax=0x50000000
set shmsys:shminfo_shmmni=0x100
set shmsys:shminfo_shmseg=0x10

 

Thanks

Ingrid

--Boundary_(ID_YgqVKM6e27aF0YmARNpKMw)--