Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id AEFA41337B92 for ; Wed, 4 May 2011 22:24:33 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 41346-01 for ; Thu, 5 May 2011 01:24:25 +0000 (UTC) X-Greylist: delayed 00:05:18.906448 by SQLgrey-1.7.6 Received: from nm2-vm1.bullet.mail.sg1.yahoo.com (nm2-vm1.bullet.mail.sg1.yahoo.com [115.178.12.241]) by mail.postgresql.org (Postfix) with SMTP id 5CE8C1337B82 for ; Wed, 4 May 2011 22:24:22 -0300 (ADT) Received: from [115.178.12.222] by nm2.bullet.mail.sg1.yahoo.com with NNFMP; 05 May 2011 01:18:59 -0000 Received: from [115.178.12.217] by tm3.bullet.mail.sg1.yahoo.com with NNFMP; 05 May 2011 01:18:59 -0000 Received: from [127.0.0.1] by omp1002.mail.sg1.yahoo.com with NNFMP; 05 May 2011 01:18:59 -0000 X-Yahoo-Newman-Property: ymail-5 X-Yahoo-Newman-Id: 762961.51664.bm@omp1002.mail.sg1.yahoo.com Received: (qmail 30991 invoked by uid 60001); 5 May 2011 01:18:59 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1304558339; bh=wFwpMD/LuP5zwcX37AXMap27gZFuG+iH7gcKhFCq2Nc=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=LybRIV0/t+VBVNxl9VpS26irvh4JEGoGcBxfPel0bGpYQPFjrqZHdAdeono7OMRESjpC3Z9PgT5RBTtX4/Vay4PB1GKa9UXNJDj/xIIqAXgXJ2iWfa17G4SkXd/Nj6cGNLc0kARA6yLdR0vucp23puFzKFvZrPEadC4p3A/n/fU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type; b=NLu9P053q7BY7rKBpyZQgk/JMkO+08XNjMVsjUL4DyMM9lvMooa5v1DnRex5INH/2qWavbkOin+fh7l30ph1rBtZ6Y8beIpDY671yAOdQFjs/ZXiAB/XJfDiDBCgmLyEY+mnXPsduyREi8WHAf2Dh95fINCRj9E8apqHNVJ8aXI=; Message-ID: <641487.23556.qm@web77304.mail.sg1.yahoo.com> X-YMail-OSG: pQrwAWQVM1npElb4LSoJmbLQ9mv3X6lVQ1lLgR9a4mC4Ym9 kQboKeSPSLp897v1xdeuB2UV60GpXF6WdaIf_cZxhxyKeIbPKlbP.1nfgTyO Xkehzdqv_VfmQ.H1drCeo_5WQ0CVXb4rU1UYk5LEp_7uPEj7RHDWD56EFkaa NrXbN9oYIVJtB2jzc6KC_RZcREF0eR7CHnlTmeOpIQ4H8Wp_dkZSIxTRIXrH aRYkvvVy0JRTE96pDQ12hkg1Yf7Lac9RFeyV2eFU_H4wOxro6bCmFvcC_BtU Y108PWXSuyT2o01icrlpYYvk- Received: from [202.169.34.218] by web77304.mail.sg1.yahoo.com via HTTP; Thu, 05 May 2011 09:18:59 SGT X-Mailer: YahooMailRC/559 YahooMailWebService/0.8.110.299900 Date: Thu, 5 May 2011 09:18:59 +0800 (SGT) From: Didik Prasetyo Subject: ask the database engine tuning on the server To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-683993274-1304558339=:23556" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.003 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=1.553, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_BL_SPAMCOP_NET=1.347, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01, T_TO_NO_BRKTS_FREEMAIL=0.01 X-Spam-Level: * X-Archive-Number: 201105/58 X-Sequence-Number: 43567 --0-683993274-1304558339=:23556 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I had a problem with performance engine database, I use the server with the= =0Afollowing specifications=0A=0A 1. its storage configuration?=0A = Storage SCSI 15K RAID 5=0A 2. how his network?=0A 2 gigabit bonding.= =0A3. type / behavior of applications that connect to the db?=0A Direc= t connects one segment.=0A4. use the machine?=0A DB only=0A5. its os?= * nix or windows?=0A Linux=0A6. how large the existing data? growth?= =0A growth 100M / day=0A=0AI had a problem with memory is always exhau= sted, causing=0Adatabase stack or very slowly, I wanted to ask how to do th= e tuning =0Apostgresql.conf settings for the above case, or whether there i= s another =0Asolution=0A=0Athanks for regard --0-683993274-1304558339=:23556 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
<= span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">I had a problem = with = performance<= /span> engin= e dat= abase, I= use<= /span> the s= erver with the following specifications

  1.= its<= /span> stora= ge co= nfiguration?
       Storage SCSI 15K RAID 5
  2. how his network2 gigabit bonding.
3. type / behavior of applicatio= ns th= at co= nnect to the db?
      Direct connects one segment.
4. use the machine= ?
&nb= sp;      DB only
5. its os? * nix = or windows?
      Linux
<= span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">6. how large the existing data<= /span>? = growth?
&n= bsp;     growth 100M / day
I <= span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">had a problem with memory is alwa= ys ex= hausted,= causing
database stack or very slowly, I wanted to ask how to do the tuning postgresql.conf settings = for <= span title=3D"Klik untuk terjemahan alternatif" class=3D"hps">the above cas= e, or = whether there is another solution

thanks for regard=0A
--0-683993274-1304558339=:23556--