From: Daniel van Ham Colchete <daniel.colchete@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: New to PostgreSQL, performance considerations
Date: Mon, 11 Dec 2006 08:36:07 -0200
Message-ID: <8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com> (raw)
In-Reply-To: <96AA0685-0BCC-4300-BB12-696FE495B008@fastcrypt.com>
References: <8a0c7af10612101141n2c7727c3r2f92345753960808@mail.gmail.com>
<430d92a20612101336r3de8862coe618277fccb4006a@mail.gmail.com>
<8a0c7af10612101702i49b5a533v4a2300d90d9dae6b@mail.gmail.com>
<96AA0685-0BCC-4300-BB12-696FE495B008@fastcrypt.com>
Hi Dave,
On 12/11/06, Dave Cramer <pg@fastcrypt.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: daniel.colchete@gmail.com
Subject: Re: New to PostgreSQL, performance considerations
In-Reply-To: <8a0c7af10612110236m1207a9daid137bbede07a6f37@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox