Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 75561477283 for ; Fri, 4 Oct 2002 10:23:46 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id ADC8A4770C9 for ; Fri, 4 Oct 2002 10:14:02 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g94EE6hR020417; Fri, 4 Oct 2002 10:14:07 -0400 (EDT) To: "Kevin Traub" Cc: pgsql-sql@postgresql.org Subject: Re: Can Postgres cache a table in memory? In-reply-to: References: Comments: In-reply-to "Kevin Traub" message dated "Thu, 03 Oct 2002 10:03:56 -0400" Date: Fri, 04 Oct 2002 10:14:06 -0400 Message-ID: <20416.1033740846@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/62 X-Sequence-Number: 9780 "Kevin Traub" writes: > I'm trying to speed up a query which returns the majority of a table so and > index isn't helpful. > I've got more than enough RAM to hold my table so, can anyone tell me if > there is there a way to force Postgres to cache a table in RAM? There is no need to do anything; if you're hitting the table a lot, it should all migrate into kernel disk buffers. regards, tom lane