Thread: few questions ..?
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.
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
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!