pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>




view thread (124+ messages)  latest in thread

Message-ID: <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com>
Permalink:  ../910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com/
Also on:    postgresql.org/message-id/910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com

 · 

reply

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