Re: pg_upgrade problem as locale difference in data centers

As we use ansible to deploy the upgrade, so mentioned the data centers situation. The PostgreSQL is single node and the upgrade will be in the same data center and same Linux server(Centos 7), just will run the ansible to upgrade PG in all Data centers. For example, in our aaa data center postgre

Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

On 9/19/21 06:28, Niels Jespersen wrote: Hello all We are often using the oracle_fdw to transfer data between Postgres (version 11+) and Oracle (version 18+). It works great. However I have a task at hand that requires inserting a few billion rows in an Oracle table from a Postgres query.

Possibilities for optimizing inserts across oracle_fdw foreign data wrapper

Hello all We are often using the oracle_fdw to transfer data between Postgres (version 11+) and Oracle (version 18+). It works great. However I have a task at hand that requires inserting a few billion rows in an Oracle table from a Postgres query. insert into t_ora (a,b,c) select a,b,c from t