Re: New to PostgreSQL, performance considerations

From: "Daniel van Ham Colchete" <daniel(dot)colchete(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: New to PostgreSQL, performance considerations
Date: 2006-12-11 10:36:07
Message-ID: 8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Dave,

On 12/11/06, Dave Cramer <pg(at)fastcrypt(dot)com> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Cramer 2006-12-11 11:04:40 Re: New to PostgreSQL, performance considerations
Previous Message Daniel van Ham Colchete 2006-12-11 10:32:43 Re: New to PostgreSQL, performance considerations