Re: Index scan startup time

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Index scan startup time
Дата
Msg-id 200603301716.13840.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: Index scan startup time  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Index scan startup time  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:
> The problem here appears to be a non-random correlation between state
> and activity, such that the desired state values are not randomly
> scattered in the activity sequence.  The planner doesn't know about
> that correlation and hence can't predict the poor startup time.

So from when to when is the startup time (the "x" in "x..y") actually
measured?  When does the clock start ticking and when does it stop?
That is what's confusing me.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

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

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: [Solved] Slow performance on Windows .NET and OleDb
Следующее
От: Tom Lane
Дата:
Сообщение: Re: CREATE INDEX rather sluggish