"Qingqing Zhou" <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend