Re: Oracle to postgres migration via ora2pg (blob data)

2019-07-31 Thread Amol Tarte
FullConvert does this job much faster than ora2pg With Warm Regards, Amol Tarte, Project Lead, Rajdeep InfoTechno Pvt. Ltd. Visit us at http://it.rajdeepgroup.com On Wed 31 Jul, 2019, 5:16 PM Niels Jespersen, wrote: > I would look at the source table in Oracle first. It looks a lot l

Re: Writing 1100 rows per second

2020-02-11 Thread Amol Tarte
I am using npgsql in my c# program, I have a table in which we need to dump data from a flat file approx. 5.5 million rows once in every 24 hours. Soon it will grow to 10 million rows. We are using npgsql binary import and all this is done (5.5 million) inserts in < 3 minutes. Then we create two in

Re: PostgreSQL DBA consulting

2020-04-13 Thread Amol Tarte
https://www.cybertec-postgresql.com/ With Warm Regards, Amol P. Tarte Project Manager, Rajdeep InfoTechno Pvt. Ltd. Visit us at http://it.rajdeepgroup.com On Tue, Apr 7, 2020, 5:21 PM daya airody wrote: > hi folks, > > we are looking for a PostgreSQL DBA to help us in tuning our database. > >