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
Список
Дерево обсуждения
speed 6.5 vs 7.0 Jeff MacDonald <jeff@pgsql.com>
Re: speed 6.5 vs 7.0 Tom Lane <tgl@sss.pgh.pa.us>
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 wantrstypemale LIKE '%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
FAQ