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

Re: Query caching

From: Frank Joerdens <frank(at)joerdens(dot)de>
To: "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 10:08:32
Message-ID: 20001101110832.B6798@rakete.joerdens.de (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Wed, Nov 01, 2000 at 10:16:58AM +0000, Poul L. Christiansen wrote:
> PostgreSQL hits the disk on UPDATE/DELETE/INSERT operations. SELECT's
> are cached, but the default cache is only ½MB of RAM. You can change
> this to whatever you want.

That sound like a very cool thing to do, and the default seems awfully
conservative, given the average server´s RAM equipment nowadays. If you
have a small Linux server with 128 MB of RAM, it would be interesting to
see what happens, performance-wise, if you increase the cache for
selects to, for instance, 64 MB. Has anyone tried to benchmark this? How
would you benchmark it? Where do you change this cache size? How do you
keep the cache from being swapped out to disk (which would presumably
all but eradicate the benefits of such a measure)?

Cheers Frank

-- 
frank joerdens               

joerdens new media
urbanstr. 116
10967 berlin
germany

e: frank(at)joerdens(dot)de
t: +49 (0)30 69597650
f: +49 (0)30 7864046 
h: http://www.joerdens.de

pgp public key: http://www.joerdens.de/pgp/frank_joerdens.asc

In response to

Responses

pgsql-hackers by date

Next:From: Karel ZakDate: 2000-11-01 10:13:03
Subject: Re: Re: [GENERAL] Query caching
Previous:From: Karel ZakDate: 2000-11-01 09:52:51
Subject: Re: Query cache import?

pgsql-general by date

Next:From: Karel ZakDate: 2000-11-01 10:13:03
Subject: Re: Re: [GENERAL] Query caching
Previous:From: Nick FankhauserDate: 2000-11-01 09:39:29
Subject: Character type delimiters - Can they be changed?

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