Re: few questions ..?

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