"Bruce Momjian" <pgman@candle.pha.pa.us> wrote
>
> Would some people please run the attached test procedure and report back
> the results? I basically need to know the patch is an improvement on
> more platforms than just my own. Thanks
>
Obviously it matches your expectation.
uname: Linux amd64 2.6.9-5.13smp #1 SMP Wed Aug 10 10:55:44 CST 2005 x86_64
x86_64 x86_64 GNU/Linux
compiler: gcc (GCC) 3.4.3 20041212
configure: '--prefix=/home/qqzhou/pginstall'
--Before patch --
real 0m1.149s
user 0m0.182s
sys 0m0.122s
real 0m1.121s
user 0m0.173s
sys 0m0.103s
real 0m1.128s
user 0m0.116s
sys 0m0.092s
-- After patch --
real 0m1.275s
user 0m0.097s
sys 0m0.160s
real 0m4.063s
user 0m0.663s
sys 0m0.377s
real 0m1.259s
user 0m0.073s
sys 0m0.160s
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
