From: | Jeff MacDonald <jeff(at)pgsql(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | speed 6.5 vs 7.0 |
Date: | 2000-06-13 16:50:12 |
Message-ID: | Pine.BSF.4.21.0006131330490.1375-100000@rage.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 wantrstypemale LIKE '%Activity Partner%')
) ORDER BY created DESC;
and here are the explains
pIII 500
NOTICE: 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
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-06-13 17:42:44 | Re: the contrib tree clean up |
Previous Message | Karel Zak | 2000-06-13 16:40:57 | the contrib tree clean up |