Clustering using dblink

From: "Yudha Setiawan" <inas_husband(at)bonbon(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Clustering using dblink
Date: 2003-05-27 12:36:43
Message-ID: 007101c3244d$46813360$ea00a8c0@yudha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-05-27 12:50:26 Re: Query Which is not supposted to list NULLS is listing
Previous Message Nigel J. Andrews 2003-05-27 09:31:16 Re: Query Which is not supposted to list NULLS is listing