Re: [PERFORM] Insert Concurrency

2017-04-18 Thread ROBERT PRICE
to speed on postgres partitioning for a future need. From: Scott Marlowe Sent: Tuesday, April 18, 2017 3:41 PM To: ROBERT PRICE Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] Insert Concurrency On Mon, Apr 17, 2017 at 8:55 PM, ROBERT PRICE wrote

[PERFORM] Insert Concurrency

2017-04-17 Thread ROBERT PRICE
I come from an Oracle background and am porting an application to postgres. App has a table that will contain 100 million rows and has to be loaded by a process that reads messages off a SQS queue and makes web service calls to insert records one row at a time in a postgres RDS instance. I know