Re: can shared cache be swapped to disk?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: flyusa2010 fly <flyusa2010(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: can shared cache be swapped to disk?
Date: 2010-12-19 07:59:33
Message-ID: AANLkTiko1U09cp1rWbg89LgrJb0gb9d3mO3VXXTspnNO@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Dec 18, 2010 at 10:11 PM, flyusa2010 fly <flyusa2010(at)gmail(dot)com> wrote:
> hi, folks!
> I see that shared cache is implemented by system v shared memory. I wonder
> whether data in this area can be swapped out to disk.
> Isn't it bad that we read data from disk, put data in shared cache, and
> finally data in shared cache is swapped to disk again!
> Why not use shmctl(..SHM_LOCK..) to pin data in main memory?
> Thanks!

I've tried that on a recent linux kernel, to see if it would allow
shared_buffers to usefully be a large fraction of total memory. It
didn't help. So either swapping wasn't the problem in the first
place, or the kernel ignores the order.

Cheers,

Jeff

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alex Hunsaker 2010-12-19 08:20:27 Re: plperlu problem with utf8
Previous Message Alex Hunsaker 2010-12-19 07:16:01 Re: plperlu problem with utf8