Re: [PERFORM] Performance problem with joins

(cost=0.00..22630.62 rows=248862 width=27)""->  Hash  (cost=1234.74..1234.74 rows=23674 width=34)""->  Seq Scan on kurs_latest kurl  (cost=0.00..1234.74 rows=23674 width=34)""->  Hash  (cost=16590.44..16590.44 rows=776044 width=19)""-&

[PERFORM] Performance problem with joins

Hi i have a severe performance problem with one of my views which has 6 to 8 joins .. any help will be appreciated.. the view is: CREATE OR REPLACE VIEW thsn.trade_view AS SELECT tra.tra_id, tra.per_id, tra.fir_id, tra.tra_dcn, tra.tra_startdate::date AS tra_startdate, tra.tra_enddate::date AS