memory allocation

From: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: memory allocation
Date: 2004-06-18 13:34:40
Message-ID: 200406181320.i5IDKLrA010944@mail.census.gov.ph
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi everyone .

How much memory should I give to the kernel and postgresql

I have 1G of memory and 120G of HD

Shared Buffers = ?

Vacuum Mem = ?

SHMAX = ?

Sorry I have so many question .I am a newbie :-(

I have 30G of data

At least 30 simultaneus users

But I will use it only for query with lot of sorting

thanks

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-06-18 13:39:30 Re: memory allocation
Previous Message Gary Cowell 2004-06-18 13:25:54 Re: Major differences between oracle and postgres performance - what can I do ?