From: Dave Cramer <pg@fastcrypt.com>
To: Daniel van Ham Colchete <daniel.colchete@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: New to PostgreSQL, performance considerations
Date: Mon, 11 Dec 2006 06:04:40 -0500
Message-ID: <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com> (raw)
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>
On 11-Dec-06, at 5:36 AM, Daniel van Ham Colchete wrote:
> 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.
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
>
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: pg@fastcrypt.com, daniel.colchete@gmail.com
Subject: Re: New to PostgreSQL, performance considerations
In-Reply-To: <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.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