pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedfew questions ..?
3+ messages / 2 participants
[nested] [flat]
* few questions ..?
@ 2003-09-25 08:36 vijaykumar M <m_vijaykumar@hotmail.com>
2003-09-25 10:07 ` Re: few questions ..? Richard Huxton <dev@archonet.com>
0 siblings, 1 reply; 3+ messages in thread
From: vijaykumar M @ 2003-09-25 08:36 UTC (permalink / raw)
To: pgsql-sql
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.
2. Is there any way to cache the table on memorry ?
In oracle, we can use the cache statement at the table creation
itself.
3. List out the main tuning parameters in postgres.conf to take care of
supporing millions of records.
Thanks & Regards
Vijay
_________________________________________________________________
Attention NRIs! Banking worries?
http://server1.msn.co.in/msnspecials/nriservices/index.asp Get smart tips.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: few questions ..?
2003-09-25 08:36 few questions ..? vijaykumar M <m_vijaykumar@hotmail.com>
@ 2003-09-25 10:07 ` Richard Huxton <dev@archonet.com>
0 siblings, 0 replies; 3+ messages in thread
From: Richard Huxton @ 2003-09-25 10:07 UTC (permalink / raw)
To: vijaykumar M <m_vijaykumar@hotmail.com>; pgsql-sql
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: few questions ..?
@ 2003-09-25 12:36 vijaykumar M <m_vijaykumar@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: vijaykumar M @ 2003-09-25 12:36 UTC (permalink / raw)
To: dev@archonet.com; pgsql-sql
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!
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-09-25 12:36 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-09-25 08:36 few questions ..? vijaykumar M <m_vijaykumar@hotmail.com>
2003-09-25 10:07 ` Richard Huxton <dev@archonet.com>
2003-09-25 12:36 Re: few questions ..? vijaykumar M <m_vijaykumar@hotmail.com>
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