Received: from mail.rdc1.sdca.home.com (imail@ha1.rdc1.sdca.home.com
	[24.0.3.66]) by hub.org (8.9.3/8.9.3) with ESMTP id AAA17960
	for <pgsql-admin@postgresql.org>; Wed, 5 Apr 2000 00:51:14 -0400 (EDT)
	(envelope-from jconway2@home.com)
Received: from JEC-NT1 ([24.0.42.111]) by mail.rdc1.sdca.home.com
	(InterMail v4.01.01.00 201-229-111) with SMTP
	id <20000405045112.EXTF11969.mail.rdc1.sdca.home.com@JEC-NT1>
	for <pgsql-admin@postgresql.org>; Tue, 4 Apr 2000 21:51:12 -0700
Received: by JEC-NT1 with Microsoft Mail
	id <01BF9E7F.E867DFA0@JEC-NT1>; Tue, 4 Apr 2000 21:51:18 -0700
Message-ID: <01BF9E7F.E867DFA0@JEC-NT1>
From: Joe Conway <jconway2@home.com>
To: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>
Subject: performance
Date: Tue, 4 Apr 2000 21:51:17 -0700
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by hub.org id AAA18007
X-Archive-Number: 200004/8

Hello,

I'm currently working with a development database, PostgreSQL 6.5.2 on RedHat 6.1 Linux. There is one fairly large table (currently ~ 1.3 million rows) which will continue to grow at about 500k rows per week (I'm considering various options to periodically archive or reduce the collected data). Is there anything I can do to cache some or all of this table in memory in order to speed queries against it? The physical file is about 130 MB. The server is a dual Pentium Pro 200 with 512 MB of RAM.

Any suggestions would be appreciated.

Joe Conway

p.s. I tried to search the archives, but it did not return any results with even the simplest of searches.