From: Richard Huxton <dev@archonet.com>
To: "vijaykumar M" <m_vijaykumar@hotmail.com>,
	pgsql-sql@postgresql.org
Subject: Re: few questions ..?
Date: Thu, 25 Sep 2003 11:07:00 +0100
User-Agent: KMail/1.5
References: <BAY2-F74kmNsNeJI2d000007ebb@hotmail.com>
In-Reply-To: <BAY2-F74kmNsNeJI2d000007ebb@hotmail.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200309251107.00552.dev@archonet.com>

On Thursday 25 September 2003 09:36, vijaykumar M wrote:
> 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.

See contrib/dblink. I think someone is looking at linking to Oracle too (but I 
might be wrong about that).

>      2. Is there any way to cache the table on memorry ?
>            In oracle, we can use the cache statement at the table creation
> itself.

PG uses the operating-system rather than replacing it. If you're using the 
table regularly it should end up in cache. If you're not using it regularly, 
you probably didn't want it in cache anyway.

>      3. List out the main tuning parameters in postgres.conf to take care
> of supporing millions of records.

See http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php
There are two documents there describing the various config settings and the 
basics of performance tuning.

Millions of records don't need too much tuning even on a standard PC, but the 
standard config settings are *very* conservative.

-- 
  Richard Huxton
  Archonet Ltd