Help on my database performance

From: "Jianshuo Niu" <jniu(at)wc-group(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Help on my database performance
Date: 2003-07-31 15:06:09
Message-ID: bgbbaa$bvt$1@main.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 tfd_catalog (cost=0.00..43769.82 rows=161282 width=10) (actual
time
=3928.64..12905.76 rows=161282 loops=1)
Total runtime: 13240.21 msec

explain analyze select productid from hm_catalog;
NOTICE: QUERY PLAN:

Seq Scan on hm_catalog (cost=0.00..22181.18 rows=277518 width=9) (actual
time=2
1.32..6420.76 rows=277518 loops=1)
Total runtime: 6772.95 msec

Thank you for your help

Josh

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Manfred Koizar 2003-07-31 17:37:40 Re: Moving postgresql.conf tunables into 2003...
Previous Message cafweb 2003-07-31 14:43:00 Re: postgresql.conf