pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

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 09:08:31 -0200
Message-ID: <8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com> (raw)
In-Reply-To: <910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.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>
	<910F5303-D606-48C7-820C-13B6535E982B@fastcrypt.com>

> >>
> >> 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 ?

If it were the case I wouldn't have any problems letting the OS use
only 256MB, but this is not my production server. My production is
built yet. It'll have at least 2GB of memory.

But it's good to know anyway.

view thread (124+ messages)  latest in thread

Message-ID: <8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com>
Permalink:  ../8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com/
Also on:    postgresql.org/message-id/8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com

copy link · copy postgr.es

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: daniel.colchete@gmail.com
  Subject: Re: New to PostgreSQL, performance considerations
  In-Reply-To: <8a0c7af10612110308q1acf767w8f55a19d6103e4cf@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