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 11:08:31
Message-ID: 8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2006-12-11 11:25:47 Re: New to PostgreSQL, performance considerations
Previous Message Daniel van Ham Colchete 2006-12-11 11:05:56 Re: New to PostgreSQL, performance considerations