Help on my database performance

От: Jianshuo Niu
Тема: Help on my database performance
Дата: ,
Msg-id: bgbbaa$bvt$1@main.gmane.org
(см: обсуждение, исходный текст)
Ответы: Re: Help on my database performance  (Manfred Koizar)
Список: pgsql-performance

Скрыть дерево обсуждения

Help on my database performance  ("Jianshuo Niu", )
 Re: Help on my database performance  (Manfred Koizar, )
 Re: Help on my database performance  ("Jianshuo Niu", )
  Re: Help on my database performance  (Manfred Koizar, )

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




В списке pgsql-performance по дате сообщения:

От: Scott Cain
Дата:
Сообщение: Re: EXTERNAL storage and substring on long strings
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Views With Unions