Clustering??

[totti24]

does postgresql supports clustering like oracle did? if so where can i get some info about it? thanks in advance

 

[rycamor]

Clustering in what sense? This word means different things in different contexts.

1. Replication and/or distributed query processing:
a.

http://www.erserver.com/

(commercial system)
b.

http://pgreplication.postgresql.org/

(still in development open-source system)

2. Clustering of records in a table to achieve better read-only search speed (OLAP-style). PostgreSQL has a CLUSTER [index] on

command to accomplish this:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=sql-cluster.html

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=app-clusterdb.html

3. Just to confuse you even more ;-), the PostgreSQL team also has a terminology called "creating a new database cluster", which is what happens when you run 'initdb' for the first time to create your data directories, etc...

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html

 

[totti24]

i know there's a clustering process (probably initialization process) to create the data directory. i want to know whether postgresql can do database clutering or not? like the RAC in Oracle where if one db server is down, automatically another db server will take over. therefore there's no downtime (if have also i believe it's minimal).

 

[rycamor]

Look at the two links I gave you in item 1 above. If you purchase one of the higher-level paid support contracts at

http://www.pgsql.com,

you automatically get erServer, as well as tech support.

-------------------------------------------

My PostgreSQL FAQ --

http://brainscraps.com/faq/pg_my.html