From: Richard Huxton <dev@archonet.com>
To: vijaykumar M <m_vijaykumar@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: few questions ..?
Date: Thu, 25 Sep 2003 11:07:00 +0100
Message-ID: <200309251107.00552.dev@archonet.com> (raw)
In-Reply-To: <BAY2-F74kmNsNeJI2d000007ebb@hotmail.com>
References: <BAY2-F74kmNsNeJI2d000007ebb@hotmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, m_vijaykumar@hotmail.com
Subject: Re: few questions ..?
In-Reply-To: <200309251107.00552.dev@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox