Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-28 Thread Pavel Stehule
2016-09-28 14:34 GMT+02:00 Mike Sofen : > *From:* Pavel Stehule*Sent:* Tuesday, September 27, 2016 9:18 PM > 2016-09-28 6:13 GMT+02:00 Pavel Stehule : > > Hi > > 2016-09-27 23:03 GMT+02:00 Mike Sofen : > > Hi gang, > > how to view

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-28 Thread Mike Sofen
From: Pavel StehuleSent: Tuesday, September 27, 2016 9:18 PM 2016-09-28 6:13 GMT+02:00 Pavel Stehule >: Hi 2016-09-27 23:03 GMT+02:00 Mike Sofen >: Hi gang, how to view the state of a

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-27 Thread Pavel Stehule
2016-09-28 6:13 GMT+02:00 Pavel Stehule : > Hi > > 2016-09-27 23:03 GMT+02:00 Mike Sofen : > >> Hi gang, >> >> >> >> On PG 9.5.1, linux, I’m running some large ETL operations, migrate data >> from a legacy mysql system into PG, upwards of 250m rows in a

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-27 Thread Pavel Stehule
Hi 2016-09-27 23:03 GMT+02:00 Mike Sofen : > Hi gang, > > > > On PG 9.5.1, linux, I’m running some large ETL operations, migrate data > from a legacy mysql system into PG, upwards of 250m rows in a transaction > (it’s on a big box). It’s always a 2 step operation – extract

Re: [GENERAL] how to monitor the progress of really large bulk operations?

2016-09-27 Thread Melvin Davidson
On Tue, Sep 27, 2016 at 5:03 PM, Mike Sofen wrote: > Hi gang, > > > > On PG 9.5.1, linux, I’m running some large ETL operations, migrate data > from a legacy mysql system into PG, upwards of 250m rows in a transaction > (it’s on a big box). It’s always a 2 step operation –

[GENERAL] how to monitor the progress of really large bulk operations?

2016-09-27 Thread Mike Sofen
Hi gang, On PG 9.5.1, linux, I'm running some large ETL operations, migrate data from a legacy mysql system into PG, upwards of 250m rows in a transaction (it's on a big box). It's always a 2 step operation - extract raw mysql data and pull it to the target big box into staging tables that