From: "vijaykumar M" <m_vijaykumar@hotmail.com>
To: dev@archonet.com, pgsql-sql@postgresql.org
Subject: Re: few questions ..?
Date: Thu, 25 Sep 2003 12:36:26 +0000
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <BAY2-F124NR2r21w8g70002fcbd@hotmail.com>


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!