[PERFORM] Postgres bulk insert/ETL performance on high speed servers - test results

2016-09-01 Thread Mike Sofen
High level summary: server ram has a significant impact on batch processing performance (no surprise), and AWS processing can largely compete with local servers IF the AWS network connection is optimized. With the recent threads about insert performance (and performance in general), I thought I'd

Re: [PERFORM] Possible to find disk IOs for a Query?

2016-09-01 Thread Mark Kirkwood
On 01/09/16 17:56, Mark Kirkwood wrote: the other way to attack this is to trace your backend postgres process (err perfmon...no idea how to do this on windows...) No idea why I thought you were on windows (maybe was reading another message just before yours) - sorry! -- Sent via pgsql-p