Re: memory allocation - Mailing list pgsql-performance

From Richard Huxton
Subject Re: memory allocation
Date
Msg-id 40D2F4F8.20600@archonet.com
Whole thread Raw
In response to memory allocation  ("Michael Ryan S. Puncia" <mpuncia@census.gov.ph>)
List pgsql-performance
Michael Ryan S. Puncia wrote:
> Hi everyone .
>
>
>
> How much memory should I give to the kernel and postgresql
>
> I have 1G of memory and 120G of HD

Devrim's pointed you to a guide to the configuration file. There's also
an introduction to performance tuning on the same site.

An important thing to remember is that the sort_mem is the amount of
memory available *per sort* and some queries can use several sorts.

--
   Richard Huxton
   Archonet Ltd

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Major differences between oracle and postgres performance
Next
From: Tom Lane
Date:
Subject: Re: *very* inefficient choice made by the planner (regarding