Dear Manfred: Thank you so much for your response. vacuum full anaylze works! explain analyze select count(*) from tfd_catalog ; NOTICE: QUERY PLAN:
explain analyze select count(*) from tfd_catalog ; NOTICE: QUERY PLAN: Aggregate (cost=15986.02..15986.02 rows=1 width=0) (actual time=1089.99..1089.9 9 rows=1 loops=1) -> Seq Scan on tfd_catalog (cost=0.00..15582.82 rows=161282 width=0) (actual time=0.11..833.41 rows=161282 loops=1) Total runtime: 1090.51 msec EXPLAIN -> Seq Scan on tfd_catalog (cost=0.00..15582.82 rows=161282 width=0) (actual time=0.11..833.41 rows=161282 loops=1) Total runtime: 1090.51 msec Could you tell me what does "Aggregate (cost=15986.02..15986.02 rows=1 width=0) (actual time=1089.99..1089.99 rows=1 loops=1)" mean? It does not show in my previous report. I appreicate it. Josh ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
