Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 33D979FA2CC for ; Mon, 11 Dec 2006 06:36:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 33276-04 for ; Mon, 11 Dec 2006 06:36:05 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.235]) by postgresql.org (Postfix) with ESMTP id 425409F931E for ; Mon, 11 Dec 2006 06:36:09 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so738024nzh for ; Mon, 11 Dec 2006 02:36:08 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=dY2RNq/RVd95+VjE5mTjTouBVf/txXv0Q29jt/3qLSaUOfnbwYFh+q8SObqAmnVS3QkYjDgakgNkMnGnwCUODzZ7P8rHxz4ZmK9C/4DZ4jcKAaFwyxite7V2qp6oKCEulr8rC/NJGngflpi1zfieE3Br/0lGeIFCbqMVTwgLesE= Received: by 10.65.243.18 with SMTP id v18mr7716308qbr.1165833367776; Mon, 11 Dec 2006 02:36:07 -0800 (PST) Received: by 10.65.215.20 with HTTP; Mon, 11 Dec 2006 02:36:07 -0800 (PST) Message-ID: <8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com> Date: Mon, 11 Dec 2006 08:36:07 -0200 From: "Daniel van Ham Colchete" To: pgsql-performance@postgresql.org Subject: Re: New to PostgreSQL, performance considerations In-Reply-To: <96AA0685-0BCC-4300-BB12-696FE495B008@fastcrypt.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <8a0c7af10612101141n2c7727c3r2f92345753960808@mail.gmail.com> <430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com> <8a0c7af10612101702i49b5a533v4a2300d90d9dae6b@mail.gmail.com> <96AA0685-0BCC-4300-BB12-696FE495B008@fastcrypt.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/215 X-Sequence-Number: 22271 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. Daniel