Re: Clustering using dblink
От | Darko Prenosil |
---|---|
Тема | Re: Clustering using dblink |
Дата | |
Msg-id | 001701c3238b$a92a3dd0$8a94bfd5@darko обсуждение исходный текст |
Ответ на | Clustering using dblink ("Yudha Setiawan" <inas_husband@bonbon.net>) |
Список | pgsql-general |
I do not think that using dblink can improve performance. Using dblink will get busy two servers instead of one, not to mention data that are send through network.
You need to specify more information about table (number of rows, indices, query plan),
and then someone might be able to help You.
In some(most) cases VACUUM ANALYZE improves performance.
----- Original Message -----
From: Yudha SetiawanSent: Tuesday, May 27, 2003 2:36 PMSubject: [GENERAL] Clustering using dblinkDear Milist,I Think this is the hard part for me,I've been porting from Ms-SQL to PostgreSQL, andAll done succesfully, but the speed is still becameour apprehension right now. we have tried to add theHardisk(SCSI) with a controler for each. And tried tospliting a view table or schema for helping I/O proccess.It's helpfull just for a while. But it's gettingSlow again right now.And the last one i had is just using dblink for splitingmy schema and table to another server. This's my partof view's script...;create view v_stock asselect * fromdblink('hostaddr=192.168.0.220port=5432dbname=d_inventoryuser=inventorypassword=',
'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.
В списке pgsql-general по дате отправления: