Re: Clustering using dblink

From: Yudha Setiawan

To: pgsql-general@postgresql.org

Sent: Tuesday, May 27, 2003 2:36 PM

Subject: [GENERAL] Clustering using dblink

Dear Milist,

I Think this is the hard part for me,

I've been porting from Ms-SQL to PostgreSQL, and

All done succesfully, but the speed is still became

our apprehension right now. we have tried to add the 

Hardisk(SCSI) with a controler for each. And tried to

spliting a view table or schema for helping I/O proccess.

It's helpfull just for a while. But it's getting

Slow again right now.

And the last one i had is just using dblink for spliting

my schema and table to another server. This's my part

of view's script...;

 

create view v_stock as

select * from

dblink('hostaddr=192.168.0.220

        port=5432

        dbname=d_inventory

        user=inventory

        password=', 
       'select * from t_stockreal')
 as t1(
 fc_branch      character(6),
 fc_stockcode   character(20),               
 fn_lastdisc3   numeric(18,0),              
 ft_note        text );

 

But It's more slow. Please somebody help me Please.

 

Thank's and GOD Bless You All.