speed 6.5 vs 7.0

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

Responses

Browse pgsql-hackers by date

  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