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 C35C7D1B50A for ; Wed, 19 Nov 2003 02:17:25 +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 69392-05 for ; Tue, 18 Nov 2003 22:16:58 -0400 (AST) Received: from b0x.supernerd.com (unknown [208.186.134.90]) by svr1.postgresql.org (Postfix) with ESMTP id 3D334D1D614 for ; Tue, 18 Nov 2003 22:16:54 -0400 (AST) Received: from trogdor (unknown [67.42.122.198]) by b0x.supernerd.com (Postfix) with ESMTP id 2EDF95FD1B; Tue, 18 Nov 2003 19:13:09 -0700 (MST) Message-ID: <021a01c3ae43$3b25a2f0$0700a8c0@trogdor> From: "Rick Gigger" To: "scott.marlowe" Cc: "PgSQL General ML" References: Subject: Re: performance problem Date: Tue, 18 Nov 2003 16:54:59 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/973 X-Sequence-Number: 52623 > Usually doesn't. More sort_mem might though. Make it something like > 16384 or 32768 (it's measured in kbytes) I thought that it was measured in 8k blocks. http://candle.pha.pa.us/main/writings/pgsql/hw_performance/node3.html > 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? rg