From: Kevin Grittner <kgrittn@ymail.com>
To: Rodrigo Barboza <rodrigombufrj@gmail.com>
To: Pavel Stehule <pavel.stehule@gmail.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: effective_cache_size on 32-bits postgres
Date: Mon, 18 Mar 2013 11:47:05 -0700 (PDT)
Message-ID: <1363632425.31395.YahooMailNeo@web162906.mail.bf1.yahoo.com> (raw)
In-Reply-To: <CANs8QJYt3C6TptfzEbCMSJvEwHh1prrtFhpNgXyc9P0z5ApANw@mail.gmail.com>
References: <CANs8QJb=nDR0=xSLx0E1LMs7uOYup6j4Ya-r4ReKdJCSbVFqHw@mail.gmail.com>
<CAFj8pRDJu4-6ZDVttqePbZv4euCMDLT=N0T5L0DmA6uv_yCbLQ@mail.gmail.com>
<CAFj8pRAROuxPQ5=v3BrLw1jLTC8HYV4be7gSAsQ90=BrRY+Spw@mail.gmail.com>
<CANs8QJYt3C6TptfzEbCMSJvEwHh1prrtFhpNgXyc9P0z5ApANw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Rodrigo Barboza <rodrigombufrj@gmail.com> wrote:
> So setting this as half of ram, as suggested in postgres tuning
> webpage should be safe?
Half of RAM is likely to be a very bad setting for any work load.
It will tend to result in the highest possible number of pages
duplicated in PostgreSQL and OS caches, reducing the cache hit
ratio. More commonly given advice is to start at 25% of RAM,
limited to 2GB on Windows or 32-bit systems or 8GB otherwise. Try
incremental adjustments from that point using your actual workload
on you actual hardware to find the "sweet spot". Some DW
environments report better performance assigning over 50% of RAM to
shared_buffers; OLTP loads often need to reduce this to prevent
periodic episodes of high latency.
--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, rodrigombufrj@gmail.com, pavel.stehule@gmail.com
Subject: Re: effective_cache_size on 32-bits postgres
In-Reply-To: <1363632425.31395.YahooMailNeo@web162906.mail.bf1.yahoo.com>
* 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