Re: New to PostgreSQL, performance considerations - Mailing list pgsql-performance

From Daniel van Ham Colchete
Subject Re: New to PostgreSQL, performance considerations
Date
Msg-id 8a0c7af10612110308q1acf767w8f55a19d6103e4cf@mail.gmail.com
Whole thread Raw
In response to Re: New to PostgreSQL, performance considerations  (Dave Cramer <pg@fastcrypt.com>)
List 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.

pgsql-performance by date:

Previous
From: "Daniel van Ham Colchete"
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: New to PostgreSQL, performance considerations