Re: Query caching

Steve Wolfe <steve@iboats.com>

From: "Steve Wolfe" <steve@iboats.com>
To: "Frank Joerdens" <frank@joerdens.de>, "Poul L. Christiansen" <poulc@cs.auc.dk>
Cc: <pgsql-general@postgresql.org>
Date: 2000-11-01T17:37:09Z
Lists: pgsql-hackers
> How do you
> keep the cache from being swapped out to disk (which would presumably
> all but eradicate the benefits of such a measure)?

  You make sure that you have enough RAM that you aren't using swap. : )

  Seriously, as cheap as RAM is today, if a machine uses swap more than
occasionally, an upgrade is in order.

steve