Re: Creating Index

> >    ->  Seq Scan on table1  (cost=0.00..20.00 rows=1000 width=0) (actual
> 
> Run VACUUM ANALYZE, then repost your EXPLAIN ANALYZE results please.
                                                                QUERY 
PLAN                                                                 

--------------------------------------------------------------------------------------------------------------------------------------------Aggregate
(cost=1858.09..1858.09 rows=1 width=156) (actualtime=5089.34..5089.34 rows=1 loops=1)  ->  Subquery Scan view1
(cost=187.86..1788.14rows=27980 width=156)  (actual time=187.74..4952.09 
 
rows=28482 loops=1)        ->  Append  (cost=187.86..1788.14 rows=27980 width=156) (actual        time=187.72..4787.18
rows=28482
 
loops=1)              ->  Subquery Scan "*SELECT* 1"  (cost=187.86..1788.14              rows=27979 width=69) (actual 
time=187.72..4687.71 rows=28482 loops=1)                    ->  Hash Join  (cost=187.86..1788.14 rows=27979
      width=69) (actual time=187.68..4332.30 
 
rows=28482 loops=1)                          Hash Cond: ("outer".f1 = "inner".f1)                          Join Filter:
("outer".f0= "inner".f0)                          ->  Seq Scan on table2  (cost=0.00..745.82
rows=28482width=47) (actual 
 
time=0.27..547.90 rows=28482 loops=1)                          ->  Hash  (cost=164.29..164.29 rows=9429
        width=22) (actual time=165.17..165.17 
 
rows=0 loops=1)                                ->  Seq Scan on table1
(cost=0.00..164.29rows=9429 width=22)                                (actual 
 
time=0.23..89.18 rows=9429 loops=1)              ->  Subquery Scan "*SELECT* 2"  (cost=0.00..0.00 rows=1
width=156)(actual time=0.03..0.03 
 
rows=0 loops=1)                    ->  Seq Scan on table3  (cost=0.00..0.00 rows=1                    width=156)
(actualtime=0.01..0.01 rows=0 
 
loops=1)Total runtime: 5114.47 msec
(13 rows)

Thanks again! Gurus.
Regards,
CN

-- 
http://www.fastmail.fm - The professional email service