Received: from academic.mssm.edu (academic.mssm.edu [146.203.1.9])
	by hub.org (8.9.3/8.9.3) with ESMTP id LAA89961
	for <pgsql-hackers@postgreSQL.org>; Fri, 3 Sep 1999 11:49:28 -0400 (EDT)
	(envelope-from ramirez@doc.mssm.edu)
Received: from doc.mssm.edu (adwr44.mssm.edu [146.203.33.44])
	by academic.mssm.edu (8.9.1/8.9.1) with ESMTP id LAA22552
	for <pgsql-hackers@postgreSQL.org>; Fri, 3 Sep 1999 11:43:43 -0400 (EDT)
Message-ID: <37CFEC5E.3AF99AA7@doc.mssm.edu>
Date: Fri, 03 Sep 1999 11:42:22 -0400
From: Edwin Ramirez <ramirez@doc.mssm.edu>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL-development <pgsql-hackers@postgreSQL.org>
Subject: Postgres Performance
References: <199909030231.WAA11134@candle.pha.pa.us>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hello,

I am using Postgres extensively for a number of projects.  I am
extremely happy with its performance and flexibility.  I am trying to
optimize the system, currently I run the postmaster with the following
setting: 
	postmaster -i -B 2048 -o '-S 2048'

I have a couple of large(?) tables which I would like to keep them in
memory (cached) so that searches are performed as fast as possible.

Is it possible to 'pin' the tables and it's indexes in memory?  
Are there any other options/values which would yield better performance?

Thanks,
-Edwin S. Ramirez-