Re: Very slow "bloat query"

2021-05-14 Thread Gilles Darold
will not bloat the catalog anymore. About your hack, I don't see other solution except running vacuum on the catalog tables more often, but I guess that this is already done or not possible. But not bloating the catalog at  such level is the right solution. -- Gilles Darold http://www.darold.net/

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

2019-07-31 Thread Gilles Darold
tion to see what is the best value. On the other side you can use --ora2pg_speed option to see at which speed Ora2Pg is able to convert the data, nothing will be written too. Use it to know if you have some win with the value of the -j option. Don't forget to do some additional test with the BLOB_LIMIT value to see if there some more improvement. If someone can prove me that they have better performances at Oracle data extraction side I will be pleased to look at this code. I hope this will help.   Regards, -- Gilles Darold http://www.darold.net/