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
|
Список | 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 по дате отправления: