Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 219A5476C36 for ; Fri, 4 Oct 2002 12:47:39 -0400 (EDT) Received: from scanmail4.cableone.net (scanmail4.cableone.net [24.116.0.124]) by postgresql.org (Postfix) with ESMTP id 14C33476B49 for ; Fri, 4 Oct 2002 12:47:38 -0400 (EDT) Received: from scanmail4.cableone.net ([10.116.0.124]) by scanmail4.cableone.net with Microsoft SMTPSVC(5.5.1877.687.68); Fri, 4 Oct 2002 09:46:44 -0700 Received: from scanmail4.cableone.net [24.116.0.124] by scanmail4.cableone.net (SMTPD32-7.04) id A5D390246; Fri, 04 Oct 2002 09:46:14 -0700 Received: from redwood ( [24.117.24.47]) by mail.cableone.net with SMTP (MailShield v2.04 - WIN32 Jul 17 2001 17:12:42); Fri, 04 Oct 2002 09:46:13 -0600 From: "David Blood" To: Subject: Pinning a table into memory Date: Fri, 4 Oct 2002 10:46:57 -0600 Message-ID: <03a301c26bc5$a799a970$1f00a8c0@redwood> MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <01c601c26bc4$73d5f900$4201a8c0@beeblebrox> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-SMTP-HELO: redwood X-SMTP-MAIL-FROM: david@matraex.com X-SMTP-PEER-INFO: [24.117.24.47] X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/263 X-Sequence-Number: 31261 In Oracle you can Pin large objects into memory to prevent frequent reloads. Is there anyway to do this with Postgres? It appears that some of our tables that get hit a lot may get kicked out of memory when we access some of our huge tables. Then they have to wait for I/O to get loaded back in. David Blood Matraex, Inc