From: Francisco Reyes <lists@stringsutils.com>
To: Greg Smith <greg@2ndquadrant.com>
Cc: Samuel Gendler <sgendler@ideasculptor.com>
Cc: FabrÃcio dos Anjos Silva <fabricio.silva@linkcom.com.br>
Cc: pgsql-performance@postgresql.org
Subject: Re: How does PG know if data is in memory?
Date: Wed, 27 Oct 2010 22:30:08 -0400
Message-ID: <cone.1288233008.267900.5695.1000@shelca> (raw)
References: <AANLkTin5G0jXUbeNdC+1s9LQpk1ZpvDuX-6n90oonen3@mail.gmail.com>
<AANLkTik5hnOcU=spN0wmWmR6_wHN=sKfVNzJeDuPTVW_@mail.gmail.com>
<4CA944EF.5040702@2ndquadrant.com>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: lists@stringsutils.com, greg@2ndquadrant.com, sgendler@ideasculptor.com, fabricio.silva@linkcom.com.br
Subject: Re: How does PG know if data is in memory?
In-Reply-To: <cone.1288233008.267900.5695.1000@shelca>
References: <AANLkTin5G0jXUbeNdC+1s9LQpk1ZpvDuX-6n90oonen3@mail.gmail.com> <AANLkTik5hnOcU=spN0wmWmR6_wHN=sKfVNzJeDuPTVW_@mail.gmail.com> <4CA944EF.5040702@2ndquadrant.com> <cone.1288233008.267900.5695.1000@shelca>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox