Re: Processor usage/tuning question

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Processor usage/tuning question
Дата
Msg-id CAMkU=1zVDkYQ5-otmBKPTD6rasnG-QaYTNkwQOJZqznrtPPiUQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Processor usage/tuning question  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-general
On Fri, Oct 10, 2014 at 2:04 PM, Jim Nasby <Jim.Nasby@bluetreble.com> wrote:
On 10/8/14, 3:17 PM, Israel Brewster wrote:
Except that the last data point received is still valid as the aircraft's current location, even if it came in several hours ago - which we may well care about. That is, some users may need to see where a given aircraft (or the entire fleet) is, even if an aircraft hasn't updated in a while. That said, I did discuss this with my higher-ups, and got the ok to take it down to four hours.

Note that in your explain output nothing is filtering by time at all; are you sure you posted the right explain?

I thought that as well, but then I noticed that the depesz site truncates the data in the html view.  Switch to the text view and the filter is there, as part of the index condition, after the long ANY list.   http://explain.depesz.com/s/H5w

Cheers,

Jeff

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

Предыдущее
От: Stephen Davies
Дата:
Сообщение: Re: psql connection issue
Следующее
От: Arun Gokule
Дата:
Сообщение: pg advisory locks