From: | Grzegorz Jaskiewicz <gj(at)pointblue(dot)com(dot)pl> |
---|---|
To: | Joshua D(dot)Drake <jd(at)commandprompt(dot)com> |
Cc: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [PATCHES] Bitmapscan changes |
Date: | 2007-03-17 21:14:35 |
Message-ID: | 9435F455-7B24-40D6-B49C-23395D760051@pointblue.com.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
This is on dual ultra 2 sparc. with ultrawide 320 scsi drives. 512MB
ram.
I had to drop size of DB, because the DB drive is 4GB (I do welecome
bigger drives as donation, if someone asks - UWscsi 320).
here are my results. With only 4.2 patch (no maintain cluster order
v5 patch). If the v5 patch was needed, please tell me - I am going
rerun it with.
hope it is usefull.
Repeat 3 times to ensure repeatable results.
Timing is on.
select_with_normal_index
--------------------------
100000
(1 row)
Time: 1727891.334 ms
select_with_normal_index
--------------------------
100000
(1 row)
Time: 1325561.252 ms
select_with_normal_index
--------------------------
100000
(1 row)
Time: 1348530.100 ms
Timing is off.
And now run the same tests with clustered index
Timing is on.
select_with_clustered_index
-----------------------------
100000
(1 row)
Time: 870246.856 ms
select_with_clustered_index
-----------------------------
100000
(1 row)
Time: 477089.456 ms
select_with_clustered_index
-----------------------------
100000
(1 row)
Time: 381880.965 ms
Timing is off.
From | Date | Subject | |
---|---|---|---|
Next Message | Luke Lonergan | 2007-03-17 21:33:19 | Re: [PATCHES] Bitmapscan changes |
Previous Message | Simon Riggs | 2007-03-17 21:11:52 | Re: CREATE INDEX and HOT (was Question:pg_classattributes and race conditions ?) |
From | Date | Subject | |
---|---|---|---|
Next Message | Jan Wieck | 2007-03-17 21:53:58 | Re: As proposed the complete changes to pg_trigger and pg_rewrite |
Previous Message | Andrew Dunstan | 2007-03-17 15:56:30 | Re: [PATCHES] xpath_array with namespaces support |