On Thu, 31 Jul 2003 16:08:11 -0400, "Jianshuo Niu" <[EMAIL PROTECTED]>
wrote:
>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.99 rows=1 loops=1)
> -> Seq Scan on tfd_catalog (c
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..
On Thu, 31 Jul 2003 11:06:09 -0400, "Jianshuo Niu" <[EMAIL PROTECTED]>
wrote:
>I ran the same explain analyze on two similar tables. However, the table
>with less data took much more time than the one with more data. Could anyone
>tell me what happened?
>Seq Scan on tfd_catalog (cost=0.00..43769.