X-Original-To: pgsql-admin@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AB061474E4F for ; Thu, 27 Feb 2003 02:28:50 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 29127-04 for ; Thu, 27 Feb 2003 02:28:40 -0500 (EST) Received: from out-mta1.plasa.com (unknown [202.134.0.69]) by postgresql.org (Postfix) with ESMTP id 7A3D14758DC for ; Thu, 27 Feb 2003 02:28:37 -0500 (EST) Received: from localhost ([127.0.0.1] helo=out-mta1.plasa.com) by out-mta1.plasa.com with esmtp (Exim 4.12) id 18oIT2-0000xG-00 for pgsql-admin@postgresql.org; Thu, 27 Feb 2003 14:28:33 +0700 Received: from exim by out-mta1.plasa.com with signature-added (Exim 4.12) id 18oIT2-0000wx-00 for pgsql-admin@postgresql.org; Thu, 27 Feb 2003 14:28:32 +0700 Received: from [61.5.113.84] (helo=aris) by out-mta1.plasa.com with esmtp (Exim 4.12) id 18oIT0-0000uC-00 for pgsql-admin@postgresql.org; Thu, 27 Feb 2003 14:28:31 +0700 Content-Type: text/plain; charset="us-ascii" From: Aris Wendy To: pgsql-admin@postgresql.org Subject: PostgreSQL performance Date: Thu, 27 Feb 2003 14:09:44 +0700 User-Agent: KMail/1.4.3 MIME-Version: 1.0 Message-Id: <200302271409.44943.aris_postgre@telkom.net> X-Bogo-Recieved-From: X-Bogosity: No, tests=bogofilter, spamicity=0.379421, version=0.10.0 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/413 X-Sequence-Number: 7611 Dear Master=20 I have already installed postgreSQL-7.3.1 in debian woody kernel 2.4.18. I = got=20 some curiousity.=20 1. I don't have wal_files in my postgresql.conf. 2. There is no SHMMIN,SHMSEG,SEMMNI,SEMMNS,SEMMSL,SEMMAP,SEMVMX in=20 /proc/sys/kernel because I want to tune up my postgreSQL server. 3. I used HP LC Netserver P133 RAM 128, and I still used postgresql.conf=20 (original). When update 2 tables in the same schema and I do it 30 times wi= th=20 the same query. The tables have 45 fields and 19000 records. Look at the=20 bellow. I used vmstat command : (at first when I turn on my PC) procs memory swap io system = cpu r b w swpd free buff cache si so bi bo in cs us sy= id 0 0 0 0 85724 1360 27652 0 0 13 1 104 7 1 0 = 99 (at firs time I used my database : psql csa) procs memory swap io system = cpu r b w swpd free buff cache si so bi bo in cs us sy= id 0 0 0 0 52848 1464 59396 0 0 10 4 104 5 1 0= 99 (at first time I update my table) procs memory swap io system c= pu r b w swpd free buff cache si so bi bo in cs us sy= id 1 0 0 0 40772 1476 70052 0 0 10 9 104 5 2 0= 98 (at 11 times) procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy= id 0 0 0 0 6536 456 106920 0 0 35 289 112 19 31 4= 64 (at 12 times) procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy= id 0 0 0 132 6548 456 106924 0 0 34 303 113 19 32 5= 63 (at 30 times) procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy= id 0 0 0 972 6436 488 108080 0 0 99 385 119 26 25 5= 71 In my postgresql.conf : autocommit=3Dtrue (by default) .....so if there is= =20 autcommit mode why potgreSQL still used memory and virtual memory to get=20 transaction. TIA Best Reagards Aris Wendy