Re: memory allocation - Mailing list pgsql-performance

From Devrim GUNDUZ
Subject Re: memory allocation
Date
Msg-id Pine.LNX.4.44.0406181631400.12266-100000@emo.org.tr
Whole thread Raw
In response to memory allocation  ("Michael Ryan S. Puncia" <mpuncia@census.gov.ph>)
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,

On Fri, 18 Jun 2004, Michael Ryan S. Puncia wrote:

> How much memory should I give to the kernel and postgresql
>
> I have 1G of memory and 120G of HD
>
> Shared Buffers = ?
>
> Vacuum Mem = ?

Maybe you should read

http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.sxw
OR
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e.html

> SHMAX = ?

SHMMAX is not that relevant with PostgreSQL, it's rather relevant with
your operating system.

Regards,
- --
Devrim GUNDUZ
devrim~gunduz.org                devrim.gunduz~linux.org.tr
            http://www.tdmsoft.com
            http://www.gunduz.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQFA0vCUtl86P3SPfQ4RAvITAJ48FV24aBN+nc2+lkRwXc79HlHV6QCfSvRA
YuGjn8hs1jvOJ2Ah9oamIJQ=
=96+i
-----END PGP SIGNATURE-----


pgsql-performance by date:

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