speed 6.5 vs 7.0

Поиск
Список
Период
Сортировка
От Jeff MacDonald
Тема speed 6.5 vs 7.0
Дата
Msg-id Pine.BSF.4.21.0006131330490.1375-100000@rage.hub.org
обсуждение исходный текст
Ответы Re: speed 6.5 vs 7.0  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
hi folks, i have 2 machines 1 is a pIII 500 with 758 megs of ram,
and one is a dual pIII 450 with 512 megs of ram. both are running
freebsd 4.0.

the 500 is running pg 6.5.3, the dual450 is running pg 7.0 

here's the load averages -

pIII 500 - 12:39PM  up 24 days, 14:33, 25 users, load averages: 2.16, 2.19, 2.18
d540   - 12:44PM  up 6 days, 17:26, 4 users, load averages: 2.61, 2.13, 1.89

here is the query

SELECT gid FROM members
WHERE active = 't'
AND  (gender = 0       AND  (wantrstypemale LIKE '%Short Term%'               OR wantrstypemale LIKE '%Marriage%'
       OR wantrstypemale LIKE '%Long Term%'               OR wantrstypemale LIKE '%Penpal%'               OR
wantrstypemaleLIKE '%Activity Partner%')
 
)  ORDER BY created DESC;

and here are the explains

pIII 500NOTICE:  QUERY PLAN:
Sort  (cost=2.05 rows=1 width=12)  ->  Index Scan using mgenders on members  (cost=2.05 rows=1 width=12)
EXPLAIN

dual pIII 450
NOTICE:  QUERY PLAN:
Sort  (cost=305.01..305.01 rows=3 width=12)  ->  Index Scan using mgenders on members  (cost=0.00..304.98 rows=3
width=12)
EXPLAIN

now is it just me or is the cost on the dualpIII450 a little out of wack ?

jeff




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

Предыдущее
От: Karel Zak
Дата:
Сообщение: the contrib tree clean up
Следующее
От: The Hermit Hacker
Дата:
Сообщение: Re: the contrib tree clean up