Re: [PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-13 Thread Dan Langille
> On Feb 11, 2016, at 4:41 PM, Dan Langille wrote: > >> On Feb 10, 2016, at 5:13 AM, Dan Langille wrote: >> >>> On Feb 10, 2016, at 2:47 AM, Jeff Janes wrote: >>> >>> On Tue, Feb 9, 2016 at 4:09 PM, Dan Langille

Re: [PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-13 Thread Dan Langille
> On Feb 13, 2016, at 10:43 AM, Dan Langille wrote: > > Today I tackled the production server. After discussion on the Bacula devel > mailing list (http://marc.info/?l=bacula-devel=145537742804482=2 > ) > I compared my

Re: [PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-11 Thread Dan Langille
> On Feb 10, 2016, at 5:13 AM, Dan Langille wrote: > >> On Feb 10, 2016, at 2:47 AM, Jeff Janes wrote: >> >> On Tue, Feb 9, 2016 at 4:09 PM, Dan Langille wrote: >>> I have a wee database server which regularly tries to insert 1.5

Re: [PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-10 Thread Dan Langille
> On Feb 10, 2016, at 2:47 AM, Jeff Janes wrote: > > On Tue, Feb 9, 2016 at 4:09 PM, Dan Langille wrote: >> I have a wee database server which regularly tries to insert 1.5 million or >> even 15 million new rows into a 400 million row table. Sometimes

[PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-09 Thread Dan Langille
I have a wee database server which regularly tries to insert 1.5 million or even 15 million new rows into a 400 million row table. Sometimes these inserts take hours. The actual query to produces the join is fast. It's the insert which is slow. INSERT INTO File (FileIndex, JobId, PathId,

Re: [PERFORM] Running lots of inserts from selects on 9.4.5

2016-02-09 Thread Jeff Janes
On Tue, Feb 9, 2016 at 4:09 PM, Dan Langille wrote: > I have a wee database server which regularly tries to insert 1.5 million or > even 15 million new rows into a 400 million row table. Sometimes these > inserts take hours. > > The actual query to produces the join is fast.