Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)
Date
Msg-id 23297.1140065694@sss.pgh.pa.us
Whole thread Raw
In response to Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-hackers
"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


pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)
Next
From: Christopher Kings-Lynne
Date:
Subject: Blog post on EnterpriseDB...maybe off topic