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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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