Performance surprise

Поиск
Список
Период
Сортировка
От Marc Howard Zuckman
Тема Performance surprise
Дата
Msg-id 19803c20392d0546949c8537013d536b
обсуждение
Список pgsql-hackers
This query took 1min 18 sec on a Pentium 90 with 64Meg.  Sort of surprised
me.  Should I have been surprised? (v6.2.1 + patches)

select address1, a.loc_name, b.loc_name, c.loc_name, d.loc_name,
e.loc_name, f.loc_name from property, location a ,
location b, location c, location d, location e,
location f where
livrm_loc=a.loc_code and dinrm_loc=b.loc_code and
breaknook_loc=c.loc_code and masterbed_loc=d.loc_code and
famrm_loc=e.loc_code and greatrm_loc=f.loc_code ;

location is a table that contains 5 rows:
loc_code|loc_name
--------+-----------
B       |Basement
E       |Entry Level
U       |Upper Level
N       |N/A
        |Unknown
(5 rows)

property is a table that contains 33 rows.




Marc Zuckman
marc@fallon.classyad.com

_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_
_     Visit The Home and Condo MarketPlace              _
_          http://www.ClassyAd.com                  _
_                                  _
_  FREE basic property listings/advertisements and searches.  _
_                                  _
_  Try our premium, yet inexpensive services for a real          _
_   selling or buying edge!                      _
_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_\_

В списке pgsql-hackers по дате отправления: