Re: [PERFORM] Insert Concurrency

2017-04-17 Thread Daniel Blanch Bataller
Yes, postgres has partitions: https://www.postgresql.org/docs/9.6/static/ddl-partitioning.html But this is not going to help much in the scenario you have. Postgres can ingest data very very fast, 100M records in seconds - minu

Re: [PERFORM] Insert Concurrency

2017-04-17 Thread David Rowley
On 18 April 2017 at 14:55, ROBERT PRICE wrote: > 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

[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

Re: [PERFORM] Create a materialized view in PostgreSQL which can be access by all the user account

2017-04-17 Thread David G. Johnston
On Mon, Apr 17, 2017 at 10:00 AM, Dinesh Chandra 12108 < dinesh.chan...@cyient.com> wrote: > Hi Experts, > > > > How can we create a materialized view in PostgreSQL which can be access by > all the user account in all Database? > ​Databases are isolated - while connected to one you cannot directl

[PERFORM] Create a materialized view in PostgreSQL which can be access by all the user account

2017-04-17 Thread Dinesh Chandra 12108
Hi Experts, How can we create a materialized view in PostgreSQL which can be access by all the user account in all Database? Regards, Dinesh Chandra