Re: Max shared_buffers

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "sathiya psql" <sathiya(dot)psql(at)gmail(dot)com>
Cc: bitaoxiao <bitaoxiao(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Max shared_buffers
Date: 2008-04-03 16:49:17
Message-ID: dcc563d10804030949q64faad5ej2ca587faf4f5cae3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Apr 3, 2008 at 4:10 AM, sathiya psql <sathiya(dot)psql(at)gmail(dot)com> wrote:
> There is NO MAX....
>
> It is according to your hardware you have, and the db you have.

Not entirely true. on 32 bit OS / software, the limit is just under 2
Gig. I'd imagine that the limit on 64 bit hardware / software is
therefore something around 2^63-somesmallnumber which is, for all
practical purposes, unlimited.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andrej Ricnik-Bay 2008-04-03 17:16:22 Re: Max shared_buffers
Previous Message Robins Tharakan 2008-04-03 13:27:27 Re: Performance Implications of Using Exceptions