Thanks richards ..i will go through that doc..
With Regards
Vijay
>From: Richard Huxton <dev@archonet.com>
>To: "vijaykumar M" <m_vijaykumar@hotmail.com>, pgsql-sql@postgresql.org
>Subject: Re: [SQL] few questions ..?
>Date: Thu, 25 Sep 2003 11:07:00 +0100
>
>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
_________________________________________________________________
Answer simple questions. Win a free honeymoon.
http://server1.msn.co.in/sp03/shaadi/index.asp Sail into the sunset!