[PERFORM] Insert Concurrency

Поиск
Список
Период
Сортировка
От ROBERT PRICE
Тема [PERFORM] Insert Concurrency
Дата
Msg-id BY2PR18MB0232E8126591217B0AB12165E1190@BY2PR18MB0232.namprd18.prod.outlook.com
обсуждение исходный текст
Ответы Re: [PERFORM] Insert Concurrency
Re: [PERFORM] Insert Concurrency
Re: [PERFORM] Insert Concurrency
Список pgsql-performance

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 slow by slow is not the ideal approach but I was wondering if postgres had partitioning or other ways to tune concurrent insert statements. Process will run 50 - 100 concurrent threads.

В списке pgsql-performance по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: [PERFORM] Create a materialized view in PostgreSQL which can beaccess by all the user account
Следующее
От: David Rowley
Дата:
Сообщение: Re: [PERFORM] Insert Concurrency