Postgres Pro
Downloads
Home   >   mailing lists

Re: How does PG know if data is in memory? - Mailing list pgsql-performance

From Francisco Reyes
Subject Re: How does PG know if data is in memory?
Date
Msg-id cone.1288233008.267900.5695.1000@shelca
Whole thread Raw
In response to How does PG know if data is in memory?  (Fabrício dos Anjos Silva<fabricio.silva@linkcom.com.br>)
Responses Re: How does PG know if data is in memory?
List pgsql-performance
Tree view 
Greg Smith writes:

> heard privately from two people who have done similar experiments on
> Linux and found closer to 8GB to be the point where performance started

So on a machine with 72GB is 8GB still the recommended value?
Usually have only 10 to 20 connections.

pgsql-performance by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: Postgres insert performance and storage requirement compared to Oracle
Next
From: Divakar Singh
Date:
Subject: Re: Postgres insert performance and storage requirement compared to Oracle