Postgres Pro
Downloads
Home   >   mailing lists

Thread: memory allocation

memory allocation

From
"Michael Ryan S. Puncia"
Date:

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

Re: memory allocation

From
Devrim GUNDUZ
Date:
-----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-----

Re: memory allocation

From
Richard Huxton
Date:
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