Re: Query caching

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: "Frank Joerdens" <frank(at)joerdens(dot)de>, "Poul L(dot) Christiansen" <poulc(at)cs(dot)auc(dot)dk>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Query caching
Date: 2000-11-01 17:37:09
Message-ID: 004e01c0442a$6c644640$50824e40@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message J. Atwood 2000-11-01 17:43:45 Increasing Table Column Size in 7.0 Syntax
Previous Message cfd 2000-11-01 17:36:07 Hardwood Website

Browse pgsql-hackers by date

  From Date Subject
Next Message Mikheev, Vadim 2000-11-01 20:28:17 RE: WAL: postmaster won't start
Previous Message Sion Morris 2000-11-01 17:07:29