X-Original-To: pgsql-performance@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id C683192347C for ; Fri, 30 May 2003 23:29:32 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 52242-07 for ; Fri, 30 May 2003 23:29:19 -0400 (EDT) Received: from chaos.mshome.net (unknown [148.64.8.86]) by developer.postgresql.org (Postfix) with ESMTP id F3B1A92349D for ; Fri, 30 May 2003 23:29:10 -0400 (EDT) Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by localhost.mshome.net (Postfix) with ESMTP id B7B631AF38B; Fri, 30 May 2003 21:29:05 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by chaos.mshome.net (Postfix) with SMTP id E6EC91AF38B; Fri, 30 May 2003 21:28:46 -0600 (MDT) Date: Fri, 30 May 2003 21:28:46 -0600 From: Robert Creager To: "scott.marlowe" Cc: pgsql-performance Subject: Re: Enabling and Disabling Sequencial Scan Message-Id: <20030530212846.26a82109.Robert_Creager@LogicalChaos.org> In-Reply-To: References: <3ED7C003.1090303@netscape.net> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed version 0.8.11claws (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="=.OO0m/UOYQwKF)k" X-Spam-Checker-Version: SpamAssassin 2.53 (1.174.2.15-2003-03-30-exp) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/295 X-Sequence-Number: 2074 --=.OO0m/UOYQwKF)k Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit On Fri, 30 May 2003 14:46:12 -0600 (MDT) "scott.marlowe" said something like: > > level cache is. On my machine it's about 800 meg. It's measured in 8k > blocks, so 100,000 * 8k ~ 800 meg. The smaller this is, the more Any thoughts on how to figure this out (disk buffer size)? For some reason, my system (2xAMD 2800+, 2Gb RAM 2.4.21 - /proc/meminfo) only shows a usage of 88kb of 'Buffers' usage, and that never changes. My 'Cached' usage is 1.7Gb. I've hit the kernel mailing list, and the one response I got said don't worry about it :-( Cheers, Rob -- O_ --=.OO0m/UOYQwKF)k Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iEYEARECAAYFAj7YIW4ACgkQgy51bQc2FFmgxQCgymRXpBOA8Gi0yN53u+KugaTl MrQAn2b0oPSs8WzKs18pU1nlAfuz2ijv =v5nx -----END PGP SIGNATURE----- --=.OO0m/UOYQwKF)k--