Re: Enough RAM for entire Database.. cost aside, is this

From: Harald Fuchs <hf517(at)protecting(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Enough RAM for entire Database.. cost aside, is this
Date: 2004-07-09 11:40:40
Message-ID: pufz81quh3.fsf@srv.protecting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <Pine(dot)BSO(dot)4(dot)58(dot)0407081408180(dot)1211(at)cyclops4(dot)esentire(dot)com>,
Edmund Dengler <edmundd(at)eSentire(dot)com> writes:

> But on the other hand, general algorithms which are designed to work under
> a wide variety of circumstances may fail in specific cases. I am thinking
> of VACUUM which would kill most caching algorithms simply because we
> cannot tell the O/S "by the by, this set of pages will not be used again,
> and therefore it would be fine to use almost none of the general cache to
> store this".

We _can_ tell that the OS: man madvise.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2004-07-09 14:05:28 Re: Training and certification
Previous Message Plant Thomas 2004-07-09 07:49:32 Problem pg_restore from 7.3 to 7.4