Re: reindex option for tuning load large data

Hi James, You should be using pgloader. Regards, Iantcho On Sun, Jun 19, 2022, 10:16 James Pang (chaolpan) wrote: > We extracted data from Oracle to csv first, already convert schema objects > from Oracle to Postgresql too. Then use COPY from csv to Postgres. > > The point is about the 2 op

RE: reindex option for tuning load large data

We extracted data from Oracle to csv first, already convert schema objects from Oracle to Postgresql too. Then use COPY from csv to Postgres. The point is about the 2 options to how to make the data load fast, pg_dump only used to dump metadata in Postgres to rebuild index and recreate constra