Re: Clustering using dblink

You should specify more info about your trouble.

On Вторник, 27 Май 2003 19:36, Yudha Setiawan wrote:
> 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.