Re: Strange Create Index behaviour

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Strange Create Index behaviour
Дата
Msg-id 20005.1140040283@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Strange Create Index behaviour  (Gary Doades <gpd@gpdnet.co.uk>)
Ответы Re: Strange Create Index behaviour  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-performance
Gary Doades <gpd@gpdnet.co.uk> writes:
> Interestingly, if I don't delete the table after a run, but just drop
> and re-create the index repeatedly it stays a pretty consistent time,
> either repeatedly good or repeatedly bad!

This is consistent with the theory of a data-dependent performance
problem in qsort.  If you don't generate a fresh set of random test
data, then you get repeatable runtimes.  With a new set of test data,
you might or might not hit the not-so-sweet-spot that we seem to have
detected.

            regards, tom lane

В списке pgsql-performance по дате отправления:

Предыдущее
От: Josh Rovero
Дата:
Сообщение: Re: Reliability recommendations
Следующее
От: Gary Doades
Дата:
Сообщение: Re: Strange Create Index behaviour