X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 9C497D1B4F1 for ; Thu, 25 Sep 2003 08:37:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 77222-06 for ; Thu, 25 Sep 2003 05:36:53 -0300 (ADT) Received: from hotmail.com (bay2-f74.bay2.hotmail.com [65.54.247.74]) by svr1.postgresql.org (Postfix) with ESMTP id 7AD57D1B53B for ; Thu, 25 Sep 2003 05:36:51 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 25 Sep 2003 01:36:52 -0700 Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP; Thu, 25 Sep 2003 08:36:52 GMT X-Originating-IP: [202.63.107.19] X-Originating-Email: [m_vijaykumar@hotmail.com] From: "vijaykumar M" To: pgsql-sql@postgresql.org Subject: few questions ..? Date: Thu, 25 Sep 2003 08:36:52 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 25 Sep 2003 08:36:52.0896 (UTC) FILETIME=[2B96E200:01C38340] X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/303 X-Sequence-Number: 15281 Hi All, I have few questions, kindly suggest your comments on this.. 1. Is that postgres supports distributed database ? In oracle, by creating Dblink we can communicate the remorte database from the local one. How you could implement this in postgres database. 2. Is there any way to cache the table on memorry ? In oracle, we can use the cache statement at the table creation itself. 3. List out the main tuning parameters in postgres.conf to take care of supporing millions of records. Thanks & Regards Vijay _________________________________________________________________ Attention NRIs! Banking worries? http://server1.msn.co.in/msnspecials/nriservices/index.asp Get smart tips.