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

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 like >

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

I would look at the source table in Oracle first. It looks a lot like audit data. Perhaps all content is not needed in Postgres. If it is, then the table and lobs may benefit from being reorganised in oracle. Alter table CLIENT_DB_AUDIT_LOG move; Alter table CLIENT_DB_AUDIT_LOG move lob

A question regarding streaming replication

Hey all, I have a questions regarding streaming replication that I would like to ask in order to understand the feature better : I have 2 nodes configured with replication (primary + secondary). In my primary I configured streaming replcation + archiving. My archive command : gzip < %p >

Re: A question regarding streaming replication

Beware, the echo command always returns the same exit status, whether the archiving had succeeded or not. You might lose WAL files! Regarding the restore command: It will be executed only if the slave is not capable of receiving all WALs via streaming replication, e. g. in case the slave was

PSQL performance - TPS

Hello, We are working on development of an application with postgresql 9.6 as backend. Application as a whole is expected to give an throughput of 100k transactions per sec. The transactions are received by DB from component firing DMLs in ad-hoc fashion i.e. the commits are fired after random

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

Le 31/07/2019 à 18:02, Amol Tarte a écrit : > 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, >

Oracle to postgres migration via ora2pg (blob data)

Hello team, We have to migrate a schema from oracle to postgres but there is one table that is having following large lob segments. This table is taking time to export. What parameters we have to set in ora2pg.conf to speed up the data export by ora2pg. Table:CLIENT_DB_AUDIT_LOG

Re: PSQL performance - TPS

On 01/08/2019 15:10, Shital A wrote: Hello, We are working on development of an application with postgresql 9.6 as backend. Application as a whole is expected to give an throughput of 100k transactions per sec. The transactions are received by DB from component firing DMLs in ad-hoc fashion