Skip site navigation (1) Skip section navigation (2)

Re: How does PG know if data is in memory?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Samuel Gendler <sgendler(at)ideasculptor(dot)com>, Fabrício dos Anjos Silva <fabricio(dot)silva(at)linkcom(dot)com(dot)br>, pgsql-performance(at)postgresql(dot)org
Subject: Re: How does PG know if data is in memory?
Date: 2010-10-28 02:30:08
Message-ID: cone.1288233008.267900.5695.1000@shelca (view raw or flat)
Thread:
Lists: pgsql-performance
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. 

In response to

Responses

pgsql-performance by date

Next:From: Divakar SinghDate: 2010-10-28 03:08:53
Subject: Re: Postgres insert performance and storage requirement compared to Oracle
Previous:From: Robert HaasDate: 2010-10-28 02:01:07
Subject: Re: Re: Postgres insert performance and storage requirement compared to Oracle

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group