Re: [GENERAL] Weird performance difference

2017-10-21 Thread israel
On 2017-10-20 16:38, Tom Lane wrote: Israel Brewster writes: Can you send "explain" (not explain analyze) for the production server? Not for the full query - it only just completed, after 70 minutes or so, and I wasn't running under EXPLAIN ANALYZE. Running with a shorter

Re: [GENERAL] Weird performance difference

2017-10-20 Thread Israel Brewster
On Oct 20, 2017, at 3:31 PM, Justin Pryzby wrote: > > On Fri, Oct 20, 2017 at 03:08:26PM -0800, Israel Brewster wrote: >> Summary: the following query takes around 12 seconds on my test machine. On >> my production machine, it's at half an hour and counting. What's

[GENERAL] Weird performance difference

2017-10-20 Thread Israel Brewster
at could explain this huge discrepancy?One difference I can think of is that my production database is replicating (streaming replication), but since this is just a select, I can't think why that would make a difference... any thoughts? ---Israe

Re: [GENERAL] sub-select with multiple records, columns

2017-06-19 Thread Israel Brewster
On Jun 19, 2017, at 12:29 PM, Thomas Kellerer wrote: > > Israel Brewster schrieb am 19.06.2017 um 22:17: >> SELECT >> ... >> (SELECT >> array_agg(to_json(row(notedate,username,note))) >> FROM sabrenotes >> INNER JOIN users ON author=users.id >&

[GENERAL] sub-select with multiple records, columns

2017-06-19 Thread Israel Brewster
and combine in code, but that's no fun... :-) -------Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK 99709(907) 450-7293---BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Isr

Re: [GENERAL] Postgresql out-of-memory kill

2017-02-01 Thread Israel Brewster
On Feb 1, 2017, at 1:45 PM, Tom Lane wrote: > > Israel Brewster writes: >> So just a bit ago I ran into a bit of excitement when the kernel decided >> to kill one of my postmaster processes due to an out-of-memory issue, > > Fun :-( > >> So a single postmast

[GENERAL] Postgresql out-of-memory kill

2017-02-01 Thread Israel Brewster
only 11 entries.What am I missing here? ---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:F

Re: [GENERAL] pg_dump Conflict with recovery

2017-01-23 Thread Israel Brewster
On Jan 23, 2017, at 10:06 AM, Jerry Sievers wrote: > > Israel Brewster writes: > >> I have a backup strategy that in part consists of doing pg_dump s on my >> various databases. In order to hopefully reduce/prevent operational >> slow-down as a result of the >&g

[GENERAL] pg_dump Conflict with recovery

2017-01-23 Thread Israel Brewster
than the max_standby_streaming_delay of 180s, and as such could be easily fixed by upping that value in the config. But is that the "right" fix? Or is there a "better" way?  -------Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport In

Re: [GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-10 Thread Israel Brewster
> On Jan 9, 2017, at 1:54 PM, Kevin Grittner wrote: > > On Mon, Jan 9, 2017 at 11:49 AM, Israel Brewster > wrote: > >> [load of new data] > >> Limit (cost=354643835.82..354643835.83 rows=1 width=9) (actual >> time=225998.319..225998.320 rows=1 loops=

Re: [GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-09 Thread Israel Brewster
he high resolution dataset, and returning that result when ready, or only using the high-resolution data set when explicitly requested. So having to wait four minutes on occasion for a result from the high-resolution set may not be an issue. That said, it would be nice to know all the options I can

Re: [GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-05 Thread Israel Brewster
5 23:09 GMT+01:00 Paul Ramsey <mailto:pram...@cleverelephant.ca>>: > Varying the segment length upwards might have a salutary effect for a while, > as the efficiency improvement of fewer inner loops battles with the > inefficiency of having more points selected by the index

Re: [GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-05 Thread Israel Brewster
path length? ---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 Servic

Re: [GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-05 Thread Israel Brewster
sable - and like mentioned, that's a worst-case scenario query. Thanks! Of course, if you have any suggestions for further improvement, I'm all ears :-) --- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fai

Re: [GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-05 Thread Israel Brewster
So apparently it is now doing a sequential scan on data rather than using the index. And, of course, sorting 20 million rows is not trivial either. Did I do something wrong with forming the query? --- Israel Brewster Systems Analyst II Ravn Alas

[GENERAL] Improve PostGIS performance with 62 million rows?

2017-01-05 Thread Israel Brewster
ce.It's perhaps worth noting that the example above is most likely a worst case scenario. I would expect the vast majority of routes to be significantly shorter, and I want to say the shorter routes query much faster [testing needed]. That said, the faster the better, even for short routes :-) -

Re: [GENERAL] Index impact on update?

2017-01-04 Thread Israel Brewster
with the additional column in about 10 minutes rather than 19+ hours. Now to see how long it takes to generate the indexes :-) Thanks again! --- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport I

Re: [GENERAL] Index impact on update?

2017-01-04 Thread Israel Brewster
ax (perhaps more efficient as well?) for populating the column. I'll give it a shot, and see how it goes! ------- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 --

[GENERAL] Index impact on update?

2017-01-04 Thread Israel Brewster
t let it run it's course? Or is there an even better option, such as perhaps exporting the data, adding the additional column in a text editor, and re-importing the data with a COPY command?Thanks for any feedback/advice you can offer! ---Israel B

[GENERAL] WAL File archive time

2016-12-05 Thread Israel Brewster
Simple question: are WAL files archived when full, or when recycled? That is, are the WAL archive files "up-to-date" other than the current WAL file, or will the archives always be wal_keep_segments behind?---Israel BrewsterSystems Anal

Re: [GENERAL] Backup "Best Practices"

2016-11-29 Thread Israel Brewster
On Nov 29, 2016, at 8:12 AM, Israel Brewster wrote: > > On Nov 28, 2016, at 10:04 PM, Jeff Janes <mailto:jeff.ja...@gmail.com>> wrote: >> >> On Mon, Nov 28, 2016 at 2:50 PM, Israel Brewster > <mailto:isr...@ravnalaska.net>> wrote: >> >>> -

Re: [GENERAL] Backup "Best Practices"

2016-11-29 Thread Israel Brewster
On Nov 28, 2016, at 10:20 PM, Thomas Kellerer wrote: > > Israel Brewster schrieb am 28.11.2016 um 23:50: >>> >>> pg_archivecleanup -n /mnt/server/archiverdir >>> 00010010.0020.backup >> >> Ok, but where does that "000

Re: [GENERAL] Backup "Best Practices"

2016-11-29 Thread Israel Brewster
On Nov 28, 2016, at 10:04 PM, Jeff Janes wrote: > > On Mon, Nov 28, 2016 at 2:50 PM, Israel Brewster <mailto:isr...@ravnalaska.net>> wrote: > >> - What is the "best" (or just a good) method of keeping the WAL archives >> under control? Obviously when I

Re: [GENERAL] Backup "Best Practices"

2016-11-28 Thread Israel Brewster
On Nov 28, 2016, at 2:13 PM, John R Pierce wrote: > > On 11/28/2016 2:50 PM, Israel Brewster wrote: >>> >>> Why wouldn't the streaming replica salvage that? Are they expected to fail >>> together? Is the NFS share onto which you want to store your ba

Re: [GENERAL] Backup "Best Practices"

2016-11-28 Thread Israel Brewster
On Nov 25, 2016, at 1:00 PM, Jeff Janes wrote: > > On Wed, Nov 23, 2016 at 10:16 AM, Israel Brewster <mailto:isr...@ravnalaska.net>> wrote: > I was wondering if someone could inform me about, or point me to an online > article about best practices for backing up a postgr

Re: [GENERAL] Backup "Best Practices"

2016-11-23 Thread Israel Brewster
On Nov 23, 2016, at 10:31 AM, John R Pierce wrote: > > On 11/23/2016 11:20 AM, Israel Brewster wrote: >> How do I determine which those are? Just based on the timestamp if the WAL >> file, such that I could do something like take the timestamp of the last >> basebackup

Re: [GENERAL] Backup "Best Practices"

2016-11-23 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

[GENERAL] Backup "Best Practices"

2016-11-23 Thread Israel Brewster
d, but how do I know what those are?- Should I be looking at any other backup methods in addition to/instead of the basebackup/WAL archive scheme?Thanks for any information! ---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial

Re: [GENERAL] Streaming replication failover/failback

2016-11-22 Thread Israel Brewster
On Nov 18, 2016, at 5:48 AM, Jehan-Guillaume de Rorthais wrote: > > On Thu, 17 Nov 2016 08:26:59 -0900 > Israel Brewster mailto:isr...@ravnalaska.net>> wrote: > >>> On Nov 16, 2016, at 4:24 PM, Adrian Klaver >>> wrote: >>> >>> On 11/16/

Re: [GENERAL] Streaming replication failover/failback

2016-11-17 Thread Israel Brewster
On Nov 16, 2016, at 11:39 PM, Jehan-Guillaume de Rorthais wrote: > > On Wed, 16 Nov 2016 15:51:26 -0900 > Israel Brewster mailto:isr...@ravnalaska.net>> wrote: > >> I've been playing around with streaming replication, and discovered that the >> followin

Re: [GENERAL] Streaming replication failover/failback

2016-11-17 Thread Israel Brewster
> On Nov 16, 2016, at 4:24 PM, Adrian Klaver wrote: > > On 11/16/2016 04:51 PM, Israel Brewster wrote: >> I've been playing around with streaming replication, and discovered that >> the following series of steps *appears* to work without complaint: >> >>

[GENERAL] Streaming replication failover/failback

2016-11-16 Thread Israel Brewster
nd my understanding about the need for a new basebackup is simply off? Does the new pg_rewind feature of 9.5 change things? If so, how?Thanks for your time! -------Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbank

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 11:16 AM, John R Pierce wrote: > > On 9/27/2016 12:06 PM, Israel Brewster wrote: >> That helps for one-time stat collection, but as I mentioned in my original >> message, since connections may not last long, I could be getting close to, >> or eve

Re: [GENERAL] Determining server load

2016-09-27 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

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 10:55 AM, Melvin Davidson wrote: > > > > On Tue, Sep 27, 2016 at 2:46 PM, Israel Brewster <mailto:isr...@ravnalaska.net>> wrote: >> >I'm still curious as to how I can track concurrent connections, ... >> >> Have you consid

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 10:55 AM, Jonathan Vanasco wrote: > > > On Sep 27, 2016, at 2:46 PM, Israel Brewster wrote: > >> I do have those on, and I could write a parser that scans through the logs >> counting connections and disconnections to give a number of current >

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
nfortunately, only seems to track connections per second and not consecutive connections), already existed, or that there was some way to have the database itself track this metric. If not, well, I guess that's another project :) --- Israel Br

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 9:55 AM, John R Pierce wrote: > > On 9/27/2016 9:54 AM, Israel Brewster wrote: >> >> I did look at pgbadger, which tells me I have gotten as high as 62 >> connections/second, but given that most of those connections are probably >> very short

Re: [GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
On Sep 27, 2016, at 10:07 AM, Adrian Klaver wrote: > > On 09/27/2016 09:54 AM, Israel Brewster wrote: >> I have a Postgresql (9.4.6) cluster that hosts several databases, used >> by about half-a-dozen different in-house apps. I have two servers set up >> as mas

[GENERAL] Determining server load

2016-09-27 Thread Israel Brewster
netThanks for any advice that can be provided! -------Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK 99709(907) 450-7293---BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brew

Re: [GENERAL] "Keyed" sequence?

2016-04-28 Thread Israel Brewster
On Apr 28, 2016, at 11:21 AM, David G. Johnston wrote: > > On Thu, Apr 28, 2016 at 12:09 PM, Israel Brewster <mailto:isr...@ravnalaska.net>> wrote: > > > > > It'll kill your performance, but if aesthetics are that important to you... > > They'

Re: [GENERAL] "Keyed" sequence?

2016-04-28 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

Re: [GENERAL] "Keyed" sequence?

2016-04-28 Thread Israel Brewster
> > On Apr 28, 2016, at 10:39 AM, Vik Fearing wrote: > > On 04/28/2016 08:30 PM, Israel Brewster wrote: >> This is probably crazy talk, but in Postgresql is there any way to have >> a "keyed" sequence? That is, I have a table with a list of departments. >>

[GENERAL] "Keyed" sequence?

2016-04-28 Thread Israel Brewster
ith triggers.Is there any elegant way of accomplishing this? Something like SELECT nextval('department_seq['ops'])? ---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFai

Re: [GENERAL] Pattern match against array elements?

2015-10-12 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

Re: [GENERAL] Pattern match against array elements?

2015-10-12 Thread Israel Brewster
On Oct 12, 2015, at 10:39 AM, Tom Lane wrote: > > Jeff Janes writes: >> On Mon, Oct 12, 2015 at 10:58 AM, Israel Brewster >> wrote: >>> My first thought was to do something like this: >>> >>> SELECT * FROM (SELECT lognum,array_agg(flightnum) as

Re: [GENERAL] Pattern match against array elements?

2015-10-12 Thread Israel Brewster
end result is the same: an array in an inner query, and trying to filter based on the contents of the array. Sorry if I confused the issue by trying to simplify the concept too much. ---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial

[GENERAL] Pattern match against array elements?

2015-10-12 Thread Israel Brewster
ator, and needs to be on the right. Of course, turning it around to be: WHERE ANY(flightnum) like '8%' gives me a syntax error. So is there any way I can run this query such that I get any rows containing a flight number that starts with an 8 (or whatever)? --

[GENERAL] Sensitivity to drive failure?

2015-10-02 Thread Israel Brewster
extra drive as well. Thanks. -------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:Frontie

Re: [GENERAL] Postgresql HA questions

2015-09-25 Thread Israel Brewster
be doing something wrong here.  ---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:Fronti

[GENERAL] Postgresql HA questions

2015-09-23 Thread Israel Brewster
should I do something like run a query on a frequently updated table and make sure the results are identical?Thanks for any suggestions and information you can provide! ---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFai

Re: [GENERAL] Group by range in hour of day

2015-03-17 Thread Israel Brewster
> On Mar 17, 2015, at 1:41 PM, Marc Mamin wrote: > > >>> On Tue, Mar 17, 2015, at 11:30 AM, Adrian Klaver wrote: >>>> On 03/17/2015 10:57 AM, Israel Brewster wrote: >>>>> >>>>> >>>>>> On Mar 17, 2015, at 9:30 AM, Pa

Re: [GENERAL] Group by range in hour of day

2015-03-17 Thread Israel Brewster
end 3/17. Right. And I will run into some of those (at least the crossing midnight), so I'll keep an eye out. --- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7293 -

Re: [GENERAL] Group by range in hour of day

2015-03-17 Thread Israel Brewster
On Mar 17, 2015, at 9:05 AM, David G. Johnston wrote: > > On Tuesday, March 17, 2015, Israel Brewster <mailto:isr...@ravnalaska.net>> wrote: > > > > On Mar 17, 2015, at 8:09 AM, Paul Jungwirth > > wrote: > > > >>> test=> select h,

Re: [GENERAL] Group by range in hour of day

2015-03-17 Thread Israel Brewster
ased on 45 minutes from row id 1 [8:15-9:00) plus the full hour [08:00-9:00) from row id 3, the hour 9 value is based on the amount of rows 1,2 and 3 that fall within the 9 hour, etc. --- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Indust

Re: [GENERAL] Group by range in hour of day

2015-03-17 Thread Israel Brewster
BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster ORG:Frontier Flying Service;MIS TITLE:PC Support Tech II EMAIL;type=INTERNET;type=WORK;type=pref:isr...@frontierflying.com TEL;type=WORK;type=pref:907-450-7293 item1.ADR;type=WORK;type=pref:;;5245 Airport Industrial Wy;Fairbanks;AK

Re: [GENERAL] Group by range in hour of day

2015-03-16 Thread Israel Brewster
On Mar 16, 2015, at 2:22 PM, David G. Johnston wrote: > > On Mon, Mar 16, 2015 at 3:13 PM, Adrian Klaver <mailto:adrian.kla...@aklaver.com>> wrote: > On 03/16/2015 02:57 PM, Israel Brewster wrote: > I have a table with two timestamp columns for the start time and end

Re: [GENERAL] Group by range in hour of day

2015-03-16 Thread Israel Brewster
On Mar 16, 2015, at 2:16 PM, Paul Jungwirth wrote: > >> I have a table with two timestamp columns for the start time and end >> time of each record (call them start and end).I'm trying to figure out >> if there is a way to group these records by "hour of day", > > I think you can do this by sel

Re: [GENERAL] Group by range in hour of day

2015-03-16 Thread Israel Brewster
On Mar 16, 2015, at 2:13 PM, Adrian Klaver wrote: > > On 03/16/2015 02:57 PM, Israel Brewster wrote: >> I have a table with two timestamp columns for the start time and end >> time of each record (call them start and end).I'm trying to figure out >> if there is a

[GENERAL] Group by range in hour of day

2015-03-16 Thread Israel Brewster
   1       |   0.5I can then easily manipulate these values to get my ultimate goal of the average, which would of course always be less than or equal to 1. Is this doable in postgress? Or would it be a better idea to simply pull the raw data and post-process in code? Thanks. --

Re: [GENERAL] Server statistics monitoring?

2015-01-30 Thread Israel Brewster
On Jan 29, 2015, at 1:20 PM, Michael Heaney wrote: > On 1/29/2015 5:12 PM, Israel Brewster wrote: >> I'm working on setting up a new PostgreSQL database server, and would like >> to be able to monitor a number of statistics on it, such as: >> >> number of

[GENERAL] Server statistics monitoring?

2015-01-29 Thread Israel Brewster
to keep this in-house.  Paid solutions are fine, as long as the cost is reasonable, but we do want full-control. Before I spend my time writing my own solution, is there anything out there that can make nice graphs of various postgresql metrics? Thanks. --

[GENERAL] Stored procedure workflow question

2014-12-10 Thread Israel Brewster
re? Thanks. ---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:PC Support Tech II

Re: [GENERAL] Yosemite (OSX 10.0) problems with Postgresql

2014-10-20 Thread Israel Brewster
-D /usr/local/pgsql/data -h * RunAtLoad UserName _postgres --- Israel Brewster Systems Analyst II Ravn Alaska 5245 Airport Industrial Rd

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

Re: [GENERAL] Sync production DB with development?

2014-10-08 Thread Israel Brewster
On Oct 8, 2014, at 9:30 AM, Emanuel Calvo wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA512 > > > > El 08/10/14 a las 14:01, Israel Brewster escibió: >> I am currently doing periodic syncs of one of my production >> databases to my development database

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

[GENERAL] Sync production DB with development?

2014-10-08 Thread Israel Brewster
another two years. I would really rather not have to wait several minutes every time I want to update my development data. ---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK 99709(907) 450-7293

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

[GENERAL] Processor usage/tuning question

2014-10-03 Thread Israel Brewster
me current postgres config values:shared_buffers: 4GBeffective_cache_size: 12GBNot sure what other information I should provide, so let me know what useful data I missed! ---Israel BrewsterSystems Analyst IIRavn Alaska5245 Airport Industrial RdFairbanks, AK

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Israel Brewster
--- Israel Brewster Computer Support Technician II Era Alaska 5245 Airport Industrial Rd Fairbanks, AK 99709 (907) 450-7250 x7293 --- BEGIN:VCARD VERSION:3.0 N:Brewster;Israel;;; FN:Israel Brewster

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Israel Brewster
On Mar 6, 2014, at 1:25 PM, Steve Crawford wrote: > On 03/06/2014 09:33 AM, Israel Brewster wrote: >> For starters, this happened again this morning (no data prior to 4:45 am and >> sequence reset), so whatever is going on appears to be reoccurring. Also, I >> forgo

Re: [GENERAL] Mysterious DB reset

2014-03-07 Thread Israel Brewster
aps the file from such) that is being loaded in, but I still don't know how or why. Closer though. Thanks for the suggestions! --- Israel Brewster Computer Support Technician II Era Alaska 5245 Airport Indu

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 6, 2014, at 10:03 AM, Adrian Klaver wrote: > On 03/06/2014 10:43 AM, Israel Brewster wrote: >> On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: >> > >>> >>> Well something is happening. See my notes on logging below to help track >>> down

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 6, 2014, at 9:03 AM, Adrian Klaver wrote: > On 03/06/2014 09:33 AM, Israel Brewster wrote: >> For starters, this happened again this morning (no data prior to 4:45 am and >> sequence reset), so whatever is going on appears to be reoccurring. Also, I >> forgo

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 5, 2014, at 10:01 AM, Thom Brown <t...@linux.com> wrote:On 5 March 2014 18:22, Israel Brewster <isr...@eraalaska.net> wrote: I have a Postgresql 9.2.4 database containing real-time tracking data for our aircraft for the past week (theoretically). It is populated by two differe

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
On Mar 5, 2014, at 10:01 AM, Alvaro Herrera wrote: > Israel Brewster wrote: > >> So my question is, aside from someone going in and mucking about in the wee >> hours of the morning, what could possibly cause this behavior? What sort of >> event could cause all dat

Re: [GENERAL] Mysterious DB reset

2014-03-06 Thread Israel Brewster
/05/2014 10:22 AM, Israel Brewster wrote: >> My first thought was "Oh, I must have a typo in my >> cleanup routine, such that it is deleting all records rather than only >> those a week old, and it's just that no one has noticed until now". So I >> looked at

[GENERAL] Mysterious DB reset

2014-03-05 Thread Israel Brewster
could cause all data to be deleted from the table, and the sequence to be reset? Especially while there is an active connection? Thanks for any ideas, however wild or off the wall :-) -------Israel BrewsterComputer Support Technician IIEra Alaska5245 Airport I

Re: [GENERAL] cross-database time extract?

2009-12-29 Thread Israel Brewster
On Dec 29, 2009, at 5:41 AM, Adrian Klaver wrote: On Monday 28 December 2009 8:58:38 am Israel Brewster wrote: On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote: On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote: This is sort of a PostgreSQL question/sort of a general SQL

Re: [GENERAL] cross-database time extract?

2009-12-28 Thread Israel Brewster
On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote: On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote: This is sort of a PostgreSQL question/sort of a general SQL question, so I apologize if this isn't the best place to ask. At any rate, I know in PostgreSQL you can issue a co

[GENERAL] cross-database time extract?

2009-12-24 Thread Israel Brewster
function to work in PostgreSQL? the date function doesn't need them, so I know it's not just a general PostgreSQL formating difference. Thanks :) ---Israel BrewsterComputer Support Technician IIFrontier Flying Service Inc.5245

Re: [GENERAL] defining yuor own commands in PG ?

2009-12-24 Thread Israel Brewster
On Dec 21, 2009, at 9:34 AM, Pavel Stehule wrote: 2009/12/21 Israel Brewster : On Dec 19, 2009, at 2:59 AM, Filip Rembiałkowski wrote: 2009/12/18 Gauthier, Dave Can you define your own commands in PG. In psql, yes: \set sel 'SELECT * FROM' :sel clients; \set desc '\

Re: [GENERAL] defining yuor own commands in PG ?

2009-12-21 Thread Israel Brewster
n you will bend postgres to mimick other DBMS, you will hide its real power from users.-- Filip RembiałkowskiJID,mailto:filip.rembialkow...@gmail.comhttp://filip.rembialkowski.net/ ---Israel BrewsterComputer Support Technician IIFronti

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-03 Thread Israel Brewster
On Dec 3, 2009, at 10:54 AM, Tom Lane wrote: Israel Brewster writes: 1) From the second paragraph of that post: If you add something like "-arch i386 -arch ppc" to CFLAGS and build normally, you get real working multiarch binaries and libraries. Which is exactly the problem th

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-03 Thread Israel Brewster
On Dec 2, 2009, at 5:16 PM, Tom Lane wrote: Israel Brewster writes: Well, I'm not trying to use the server or client programs from this build - I just want the universal libraries for my programs. My point in this last section, however, doesn't necessarily extend as far as actua

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-02 Thread Israel Brewster
On Dec 2, 2009, at 8:26 AM, Tom Lane wrote: Israel Brewster writes: That said, I did sort of get this to work. What I ended up doing was building for each architecture separately (but on the same machine), then using lipo to combine the resulting libraries. When I took all but one

Re: [GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-02 Thread Israel Brewster
On Dec 2, 2009, at 1:03 AM, Dave Page wrote: 2009/12/2 Grzegorz Jaśkiewicz : On Tue, Dec 1, 2009 at 11:43 PM, Israel Brewster > wrote: I am trying to create a static, universal (x86 and ppc at least - 64 bit architectures are optional) build of the PostgreSQL libraries on a Mac O

[GENERAL] Build universal binary on Mac OS X 10.6?

2009-12-01 Thread Israel Brewster
really just need the library for my apps to link against, I don't care if the server or client programs compile. What am I doing wrong here? How can I get this to work? Thanks. -------Israel BrewsterComputer Support Technician IIFrontier Flying Service Inc

[GENERAL] RE: Postgresql over ppc4 °

2006-03-18 Thread Ivan Israel Azuara Hernandez
Title: RE: Postgresql over ppc4 ° _ De:     Ivan Israel Azuara Hernandez  Enviado el: Viernes, 17 de Marzo de 2006 09:26 p.m. Para:   'pgsql-general@postgresql.org' CC: Ivan Israel Azuara Hernandez Asunto: Postgresql

[GENERAL] Postgresql over ppc4 °

2006-03-18 Thread Ivan Israel Azuara Hernandez
Title: Postgresql over ppc4 ° Hi. Where can i download the postgresql-7.4-3 release for ppc64 ?. What postgresql release is compatible for this kind of arquitecture ?. My server is a pseries p520/power 5/64 bits. Thank's in advance ! Ivan Azuara

[GENERAL] PostgreSQL On the Mac? OS9 or OSX?

2001-08-31 Thread Israel Evans
In looking over the documentation, I haven't seen any evidence of PostgreSQL working on the Mac. Is this the case, or am I missing something. Has anyone heard of it ever being used on a mac? Thanks, ~Israel~ ---(end of broadcast)---