[Fwd: Re: [PERFORM] Max shared_buffers]

2008-04-03 Thread Justin
Scott Marlowe wrote: On Thu, Apr 3, 2008 at 4:10 AM, sathiya psql <[EMAIL PROTECTED]> 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

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread Craig Ringer
Andrej Ricnik-Bay wrote: > On 04/04/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote: >> Not entirely true. on 32 bit OS / software, the limit is just under 2 >> Gig. That depends on the OS. On Linux it's AFAIK closer to 3GB because of less address space being consumed by the kernel, though I think

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread Scott Marlowe
On Thu, Apr 3, 2008 at 11:16 AM, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote: > On 04/04/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote: > > Not entirely true. on 32 bit OS / software, the limit is just under 2 > > Gig. > > Where do you get that figure from? > > There's an architectural (theor

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread Matthew
On Fri, 4 Apr 2008, Andrej Ricnik-Bay wrote: On 04/04/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote: Not entirely true. on 32 bit OS / software, the limit is just under 2 Gig. Or are you talking about some Postgres limitation? Since the original question was: What can be set as max of ¿½

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread Andrej Ricnik-Bay
On 04/04/2008, Scott Marlowe <[EMAIL PROTECTED]> wrote: > Not entirely true. on 32 bit OS / software, the limit is just under 2 > Gig. Where do you get that figure from? There's an architectural (theoretical) limitation of RAM at 4GB, but with the PAE (that pretty much any CPU since the Pentium

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread Scott Marlowe
On Thu, Apr 3, 2008 at 4:10 AM, sathiya psql <[EMAIL PROTECTED]> 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

Re: [PERFORM] Max shared_buffers

2008-04-03 Thread sathiya psql
There is NO MAX It is according to your hardware you have, and the db you have. 2008/4/3 bitaoxiao <[EMAIL PROTECTED]>: > > What can be set as max of postgreSQL shared_buffers and work_mem > > 2008-04-03 > -- > bitaoxiao > >

[PERFORM] Max shared_buffers

2008-04-02 Thread bitaoxiao
What can be set as max of postgreSQL shared_buffers and work_mem 2008-04-03 bitaoxiao