Re: Processor usage/tuning question - Mailing list pgsql-general

From Jeff Janes
Subject Re: Processor usage/tuning question
Date
Msg-id CAMkU=1zVDkYQ5-otmBKPTD6rasnG-QaYTNkwQOJZqznrtPPiUQ@mail.gmail.com
Whole thread Raw
In response to Re: Processor usage/tuning question  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List 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 by date:

Previous
From: Stephen Davies
Date:
Subject: Re: psql connection issue
Next
From: Arun Gokule
Date:
Subject: pg advisory locks