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

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

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

pgsql-general by date

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

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