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