Re: Enough RAM for entire Database.. cost aside, is this - Mailing list pgsql-general

From Harald Fuchs
Subject Re: Enough RAM for entire Database.. cost aside, is this
Date
Msg-id pufz81quh3.fsf@srv.protecting.net
Whole thread Raw
In response to Enough RAM for entire Database.. cost aside, is this going to be fastest?  ("Andy B" <abhousehuntRE-M--O--V-E@blueyonder.co.uk>)
List pgsql-general
In article <Pine.BSO.4.58.0407081408180.1211@cyclops4.esentire.com>,
Edmund Dengler <edmundd@eSentire.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.

pgsql-general by date:

Previous
From: Thomas Mueller
Date:
Subject: Re: Column name 'user' not allowed?
Next
From: Jeff Eckermann
Date:
Subject: Re: Training and certification