Re: Changing the default configuration (was Re:

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Changing the default configuration (was Re:
Date: 2003-02-13 20:47:08
Message-ID: 87znozkiwj.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers pgsql-performance


> On Wed, 12 Feb 2003, Bruce Momjian wrote:
> >
> > And part of the reason is because some/most BSD's map the page tables
> > into physical RAM (kernel space) rather than use some shared page table
> > mechanism. This is good because it prevents the shared memory from
> > being swapped out (performance disaster).

Well, it'll only be swapped out if it's not being used...

In any case you can use madvise() to try to avoid that, but it doesn't seem
likely to be a problem since they would probably be the most heavily used
pages in postgres.

--
greg

In response to

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2003-02-13 22:58:18 Re: [HACKERS] Changing the default configuration
Previous Message Ketrien Saihr-Kenchedra 2003-02-13 20:23:16 Re: PostgreSQL Benchmarks

Browse pgsql-hackers by date

  From Date Subject
Next Message scott.marlowe 2003-02-13 21:07:50 Re: location of the configuration files
Previous Message Steve Crawford 2003-02-13 20:28:07 Re: location of the configuration files

Browse pgsql-performance by date

  From Date Subject
Next Message Nick Pavlica 2003-02-13 23:19:12 Re: JBoss CMP Performance Problems with PostgreSQL 7.2.3
Previous Message Josh Berkus 2003-02-13 20:08:22 Re: cost and actual time