Re: memory allocation

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Michael Ryan S(dot) Puncia" <mpuncia(at)census(dot)gov(dot)ph>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: memory allocation
Date: 2004-06-18 13:58:16
Message-ID: 40D2F4F8.20600@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message pginfo 2004-06-18 13:59:02 Re: Major differences between oracle and postgres performance
Previous Message Richard Huxton 2004-06-18 13:56:14 Re: Major differences between oracle and postgres performance