X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7D8D2D7839 for ; Fri, 2 Sep 2005 06:23:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94231-05 for ; Fri, 2 Sep 2005 09:23:49 +0000 (GMT) Received: from mailserv.pune.wibhu.com (unknown [210.212.168.94]) by svr1.postgresql.org (Postfix) with ESMTP id C51A8D77E5 for ; Fri, 2 Sep 2005 06:23:45 -0300 (ADT) Received: from Akshay ([192.168.1.131]) by mailserv.pune.wibhu.com (8.12.8/8.12.5) with ESMTP id j829Ivs0024658; Fri, 2 Sep 2005 14:49:03 +0530 From: "Akshay Mathur" To: "'Ron'" Cc: Subject: Re: Massive performance issues Date: Fri, 2 Sep 2005 14:53:58 +0530 Message-ID: <002901c5afa0$0dcddab0$8301a8c0@pune.wibhu.com> 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.2627 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal In-Reply-To: <6.2.3.4.0.20050901163955.021b3708@pop.earthlink.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.095 required=5 tests=[AWL=0.095] X-Spam-Level: X-Archive-Number: 200509/45 X-Sequence-Number: 14353 Ron, Can you give me some pointers to make the tables RAM resident. If one does so, is the program accessing the data need to change. Does pgsql take care to write the data to disk? Regards, akshay --------------------------------------- Akshay Mathur SMTS, Product Verification AirTight Networks, Inc. (www.airtightnetworks.net) O: +91 20 2588 1555 ext 205 F: +91 20 2588 1445 -----Original Message----- From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of Ron Sent: Friday, September 02, 2005 2:36 AM To: Tom Lane; pgsql-performance@postgresql.org Subject: Re: [PERFORM] Massive performance issues Even better, if the table(s) can be made RAM resident, then searches, even random ones, can be very fast. He wants a 1000x performance improvement. Going from disk resident to RAM resident should help greatly in attaining that goal.