Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Database Clustering on multiple harddisk


  • From: arie nugraha <dicarve(at)gmail(dot)com>
  • To: pgsql-general(at)postgresql(dot)org
  • Subject: Re: Database Clustering on multiple harddisk
  • Date: Tue, 20 Jun 2006 13:03:27 +0700
  • Message-id: <44978FAF(dot)407(at)gmail(dot)com>

Thanks a Alex,

But can tou give a bit explanation about multiple separate tablespace and HBA, or is there any resources, tutorial on how to use this features on postgresql

Thanks a lot


Alex Turner wrote:
I think you may be a little confused...

Last time I checked, Oracle RAC doesn't actualy support clustering the I/O, it's one Database backend with multiple instances on the front-end, which is only clustering the CPU bound part (it's also VERY expensive).

If by clustering you mean multiple seperate tablespaces, then Postgresql does support them.

If you mean RAID, then that is implemented by the HBA (host bus adapter), and is transparent to Postgresql.

If you are looking for replication, many people find Slony a good add-on.

Alex

On 6/20/06, *Arie Nugraha* <dicarve(at)gmail(dot)com <mailto:dicarve(at)gmail(dot)com>> wrote:

    Hi list,

    I am new postgresql user and i had read the documentation but
    i dont if PostgreSQL support database clustering on multiple harddisk
    (multiple I/O, just like DB2 and Oracle does)
    or not.

    If postgreSQL support the database clustering is there any
    documentation or tutorial that explain how to do it?

    Thanks all.






Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group