Re: [GENERAL] Processor usage/tuning question

2014-10-13 Thread Israel Brewster
--- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 --- BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster ORG:Frontier Flying Service

Re: [GENERAL] Processor usage/tuning question

2014-10-10 Thread Jeff Janes
On Fri, Oct 10, 2014 at 2:04 PM, Jim Nasby 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

Re: [GENERAL] Processor usage/tuning question

2014-10-10 Thread Jim Nasby
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

Re: [GENERAL] Processor usage/tuning question

2014-10-08 Thread Israel Brewster
---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK 99709(907) 450-7293---BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster ORG:Frontier Flying Service;MIS TITLE

Re: [GENERAL] Processor usage/tuning question

2014-10-08 Thread Jeff Janes
On Tue, Oct 7, 2014 at 12:06 PM, israel wrote: > > Thank you all for the advice. It looks like the load is due to a query > that is taking around 1300ms to complete - a query that is run by every > client connected (probably half a dozen or so, although I don't have > specific numbers), every fif

Re: [GENERAL] Processor usage/tuning question

2014-10-07 Thread israel
On 10/03/2014 6:28 pm, Andy Colson wrote: On 10/03/2014 04:40 PM, Alan Hodgson wrote: On Friday, October 03, 2014 11:24:31 AM Israel Brewster wrote: I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some stats today, I saw that it was handling about 4-5 transactions/second

Re: [GENERAL] Processor usage/tuning question

2014-10-07 Thread Emanuel Calvo
El 03/10/14 a las 16:24, Israel Brewster escibió: > I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at > some stats today, I saw that it was handling about 4-5 > transactions/second (according to the SELECT > sum(xact_commit+xact_rollback) FROM pg_stat_database; query), and an >

Re: [GENERAL] Processor usage/tuning question

2014-10-06 Thread Jim Nasby
On 10/3/14, 2:24 PM, Israel Brewster wrote: I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some stats today, I saw that it was handling about 4-5 transactions/second (according to the SELECT sum(xact_commit+xact_rollback) FROM pg_stat_database; query), and an instance of

Re: [GENERAL] Processor usage/tuning question

2014-10-03 Thread Andy Colson
On 10/03/2014 04:40 PM, Alan Hodgson wrote: On Friday, October 03, 2014 11:24:31 AM Israel Brewster wrote: I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some stats today, I saw that it was handling about 4-5 transactions/second (according to the SELECT sum(xact_commit+xac

Re: [GENERAL] Processor usage/tuning question

2014-10-03 Thread Alan Hodgson
On Friday, October 03, 2014 11:24:31 AM Israel Brewster wrote: > I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some > stats today, I saw that it was handling about 4-5 transactions/second > (according to the SELECT sum(xact_commit+xact_rollback) FROM > pg_stat_database; quer

[GENERAL] Processor usage/tuning question

2014-10-03 Thread Israel Brewster
I have a Postgresql 9.3.5 server running on CentOS 6.5. In looking at some stats today, I saw that it was handling about 4-5 transactions/second (according to the SELECT sum(xact_commit+xact_rollback) FROM pg_stat_database; query), and an instance of the postmaster process was consistently showing