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.
Hi! There:
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?
Here is the explain analyze:
explain analyze select productid from tfd_catalog;
NOTICE: QUERY PLAN:
Seq Scan on
