Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)
Qingqing Zhou <zhouqq@cs.toronto.edu>
From: "Qingqing Zhou" <zhouqq@cs.toronto.edu>
To: pgsql-hackers@postgresql.org
Date: 2006-02-16T04:47:50Z
Lists: pgsql-hackers, pgsql-performance
"Tom Lane" <tgl@sss.pgh.pa.us> wrote > "Qingqing Zhou" <zhouqq@cs.toronto.edu> writes: > > By "did this 100 times" do you mean generate a sequence of at most > > 200000*100 numbers, and for every 200000 numbers, the first half are all > > zeros and the other half are uniform random numbers? > > No, I mean I ran the bit of SQL script I gave 100 separate times. > I must misunderstand something here -- I can't figure out that why the cost of the same procedure keep climbing? Regards, Qingqing