Skip site navigation (1) Skip section navigation (2)

PostgreSQL not utilising available memory

From: Antony Paul <antonypaul24(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: PostgreSQL not utilising available memory
Date: 2005-01-25 13:01:45
Message-ID: 2989532e05012505011e5a0cfa@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi all,
    I am running PostgreSQL 7.3.3 on a RHL 7.0 box with PIII and 512
MB RAM. Recenlty I upgraded the kernel from 2.2.16 to 2.4.28. Now the
problem is Postgres is using only half of the memory now while before
upgrading the kernel it was using full memory plus swap. If Postgres
use the full available memory will it run faster ?. I disabled
Higmemory support while compiling kernel.

>From Top

                  total       used       free     shared    buffers     cached
Mem:           501        209        292          0          2        173
-/+ buffers/cache:         34        467
Swap:          501           0         501


rgds
Antony Paul

pgsql-performance by date

Next:From: Stephan SzaboDate: 2005-01-25 14:01:25
Subject: Re: How to boost performance of ilike queries ?
Previous:From: Steve PoeDate: 2005-01-25 11:57:24
Subject: Ideal disk setup for Postgresql 7.4?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group