X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 4EFFAD1D783 for ; Wed, 19 Nov 2003 02:27:24 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 71055-02 for ; Tue, 18 Nov 2003 22:26:56 -0400 (AST) Received: from asmodeus.mcnaught.org (sp-260-1.net4.netcentrix.net [4.21.254.118]) by svr1.postgresql.org (Postfix) with ESMTP id 25B1DD1B4E8 for ; Tue, 18 Nov 2003 22:26:31 -0400 (AST) Received: from doug by asmodeus.mcnaught.org with local (Exim 3.36 #1) id 1AMI2V-0004jk-00; Tue, 18 Nov 2003 21:25:55 -0500 To: "Rick Gigger" Cc: "scott.marlowe" , "PgSQL General ML" Subject: Re: performance problem References: <021a01c3ae43$3b25a2f0$0700a8c0@trogdor> From: Doug McNaught Date: 18 Nov 2003 21:25:55 -0500 In-Reply-To: "Rick Gigger"'s message of "Tue, 18 Nov 2003 16:54:59 -0700" Message-ID: <8765hhqeks.fsf@asmodeus.mcnaught.org> Lines: 14 X-Mailer: Gnus v5.7/Emacs 20.7 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/974 X-Sequence-Number: 52624 "Rick Gigger" writes: > > That's VERY high. When postgresql has to manage a lot of buffers it > > actually is slower than letting the kernel in Linux or BSD do it for you. > > Even if you've got the memory to spare? Does postgres actually slow down > just because it's slower to manager a lot of them just or because you're > taking the memory away from the kernel so the kernel has to swap more? The latter, mainly, I think. Also you *really* don't want your kernel to swap out any of your shared buffers, which can happen if they take up a significant portion of RAM... -Doug