Re: effective_cache_size on 32-bits postgres

From: Rob Wultsch <wultsch(at)gmail(dot)com>
To: Rodrigo Barboza <rodrigombufrj(at)gmail(dot)com>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: effective_cache_size on 32-bits postgres
Date: 2013-03-18 18:14:22
Message-ID: CAGdn2ugsM_NQz2VJkuaH-iZd+8sp--H0hJ0A8xfXQfqj6HnmRQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Mar 18, 2013 at 10:53 AM, Rodrigo Barboza
<rodrigombufrj(at)gmail(dot)com> wrote:
> Hi guys, I am worried about the effective_cache_size.
> I run a 32-bits postgres installation on a machine with 64 bits kernel.
> Should I limit effective_cache_size to a maximum of 2.5gb?

That variables refers to fs cache, so 32 bit pg should not matter.
Shared buffers and similar variables will be another matter.

Why the heck are you running 32 bit pg on a 64 bit system? You are
almost certainly doing it wrong.

--
Rob Wultsch
wultsch(at)gmail(dot)com

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Pavel Stehule 2013-03-18 18:15:37 Re: effective_cache_size on 32-bits postgres
Previous Message Rodrigo Barboza 2013-03-18 17:53:39 effective_cache_size on 32-bits postgres