Postgres Pro
Downloads
Home   >   mailing lists

memory allocation - Mailing list pgsql-performance

From Michael Ryan S. Puncia
Subject memory allocation
Date
Msg-id 200406181320.i5IDKLrA010944@mail.census.gov.ph
Whole thread Raw
Responses Re: memory allocation
Re: memory allocation
List pgsql-performance
Tree view

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 L

 

I have 30G of data

At least 30 simultaneus users

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

 

thanks

pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Major differences between oracle and postgres performance
Next
From: Gary Cowell
Date:
Subject: Re: Major differences between oracle and postgres performance - what can I do ?