X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 974CFD1B51E for ; Fri, 24 Oct 2003 15:43:21 +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 17140-06 for ; Fri, 24 Oct 2003 12:42:50 -0300 (ADT) Received: from yertle.kcilink.com (yertle.kcilink.com [216.194.193.105]) by svr1.postgresql.org (Postfix) with ESMTP id D0A03D1B4FB for ; Fri, 24 Oct 2003 12:42:49 -0300 (ADT) Received: by yertle.kcilink.com (Postfix, from userid 100) id 33EDE2178A; Fri, 24 Oct 2003 11:42:44 -0400 (EDT) From: Vivek Khera MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16281.18548.53239.394135@yertle.int.kciLink.com> Date: Fri, 24 Oct 2003 11:42:44 -0400 To: Josh Berkus Cc: pgsql-performance@postgresql.org Subject: Re: slow select In-Reply-To: <200310240822.57737.josh@agliodbs.com> References: <906E2C446A276048A1BE283F17BCB12CDB4230@encounter.fairind.fairfield.com> <200310221442.56816.josh@agliodbs.com> <200310240822.57737.josh@agliodbs.com> X-Mailer: VM 7.14 under 21.4 (patch 12) "Portable Code" XEmacs Lucid X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/617 X-Sequence-Number: 4365 >>>>> "JB" == Josh Berkus writes: JB> Vivek, >> Assuming your OS will use that much RAM for the cache... the whole >> world's not Linux :-) JB> It's not? Darn! :-) JB> Actually, what OS's can't use all idle ram for kernel cache? I JB> should note that in my performance docs .... FreeBSD. Limited by the value of "sysctl vfs.hibufspace" from what I understand. This value is set at boot based on available RAM and some other tuning parameters.