Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BE2B69F9F75 for ; Mon, 11 Dec 2006 07:04:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 92842-06 for ; Mon, 11 Dec 2006 07:04:32 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by postgresql.org (Postfix) with SMTP id C02C09FA162 for ; Mon, 11 Dec 2006 07:04:35 -0400 (AST) Received: (qmail 19366 invoked from network); 11 Dec 2006 11:04:34 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.14?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 11 Dec 2006 11:04:34 -0000 In-Reply-To: <8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com> References: <8a0c7af10612101141n2c7727c3r2f92345753960808@mail.gmail.com> <430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com> <8a0c7af10612101702i49b5a533v4a2300d90d9dae6b@mail.gmail.com> <96AA0685-0BCC-4300-BB12-696FE495B008@fastcrypt.com> <8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v752.3) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com> Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Dave Cramer Subject: Re: New to PostgreSQL, performance considerations Date: Mon, 11 Dec 2006 06:04:40 -0500 To: Daniel van Ham Colchete X-Mailer: Apple Mail (2.752.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/216 X-Sequence-Number: 22272 On 11-Dec-06, at 5:36 AM, Daniel van Ham Colchete wrote: > Hi Dave, > > On 12/11/06, Dave Cramer wrote: >> Hi Daniel >> On 10-Dec-06, at 8:02 PM, Daniel van Ham Colchete wrote: >> >> > Hi Gene, >> > >> > at my postgresql.conf, the only non-comented lines are: >> > fsync = off >> This can, and will result in lost data. > > I know... If there is a power failure things can happen. I'm know, but > the performance dif is really really big I just have to decide if I'm > willing to take that chance or not. > >> > lc_messages = 'C' >> > lc_monetary = 'C' >> > lc_numeric = 'C' >> > lc_time = 'C' >> >> How much memory does this machine have and what version of postgresql >> are you using? > It's only a test server with 512MB RAM, I only used it to see how well > would the PostgreSQL do in a ugly case. Given that optimal performance for postgresql can require up to 50% of available memory, you are going to leave the OS with 256MB of memory ? Dave > > Daniel > > ---------------------------(end of > broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq >