Re: Docs about buffers and sortmem setting

From: "Bjoern Metzdorf" <bm(at)turtle-entertainment(dot)de>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Docs about buffers and sortmem setting
Date: 2002-11-14 12:19:57
Message-ID: 00d701c28bd8$28ecce80$0564a8c0@toolteam.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> The general rule of thumb is to try about 25% of physical memory for
> your buffer size. Some people like to increase from there, until
> swapping starts, and then back off; but there are arguments against
> doing this, given the efficiency of modern filesystem buffering.

How about 32-bit Linux machines with more than 1 GB RAM? We have a 2 GB RAM
machine running, and I gave 800 MB to postgres shared buffers. AFAIK Linux
user space can handle only 1 GB and the rest is for kernel buffer and
cache..

Regards,
Bjoern

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrew Sullivan 2002-11-14 13:35:14 Re: Docs about buffers and sortmem setting
Previous Message Andrew Sullivan 2002-11-14 11:56:14 Re: Docs about buffers and sortmem setting