Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: "Qingqing Zhou" <zhouqq@cs.toronto.edu>
Cc: pgsql-hackers@postgresql.org
Date: 2006-02-16T04:54:54Z
Lists: pgsql-hackers, pgsql-performance
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> "Tom Lane" <tgl@sss.pgh.pa.us> wrote
>> 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?

No, the run cost varies randomly depending on the random data supplied
by the test script.  The reason the numbers are increasing is that I
sorted them for ease of inspection.

			regards, tom lane