X-Original-To: pgsql-hackers@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 10491475AFA for ; Thu, 13 Feb 2003 15:47:11 -0500 (EST) Received: from sabre.velocet.net (sabre.velocet.net [216.138.209.205]) by postgresql.org (Postfix) with ESMTP id D6038475A9E for ; Thu, 13 Feb 2003 15:47:09 -0500 (EST) Received: from stark.dyndns.tv (H162.C233.tor.velocet.net [216.138.233.162]) by sabre.velocet.net (Postfix) with ESMTP id 77272137F46; Thu, 13 Feb 2003 15:47:10 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.dyndns.tv with smtp (Exim 3.36 #1 (Debian)) id 18jQGC-0000qm-00; Thu, 13 Feb 2003 15:47:08 -0500 To: pgsql-hackers@postgresql.org Subject: Re: Changing the default configuration (was Re: References: <200302130236.h1D2ajh17527@candle.pha.pa.us> In-Reply-To: From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 13 Feb 2003 15:47:08 -0500 Message-ID: <87znozkiwj.fsf@stark.dyndns.tv> Lines: 16 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/636 X-Sequence-Number: 35578 > 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