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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)
Дата
Msg-id 23297.1140065694@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
Список 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 по дате отправления:

Предыдущее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: qsort again (was Re: [PERFORM] Strange Create Index behaviour)
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Blog post on EnterpriseDB...maybe off topic