load.
>
>
>
> *From:* Jeff Janes
> *Sent:* Sunday, June 19, 2022 4:01 AM
> *To:* James Pang (chaolpan)
> *Cc:* pgsql-performance@lists.postgresql.org
> *Subject:* Re: reindex option for tuning load large data
>
>
>
>
>
>
>
> On Fri, Jun 17, 2022 a
tuning load large data
On Fri, Jun 17, 2022 at 1:34 AM James Pang (chaolpan)
mailto:chaol...@cisco.com>> wrote:
Hi ,
We plan to migrate large database from Oracle to Postgres(version 13.6, OS
Redhat8 Enterprise), we are checking options to make data load in Postgres
fast. Data vol
On Fri, Jun 17, 2022 at 1:34 AM James Pang (chaolpan)
wrote:
> Hi ,
>
> We plan to migrate large database from Oracle to Postgres(version 13.6,
> OS Redhat8 Enterprise), we are checking options to make data load in
> Postgres fast. Data volume is about several TB, thousands of indexes,
> many
ect: Re: reindex option for tuning load large data
I believe you should be able to use reindexdb with parallel jobs:
https://www.postgresql.org/docs/13/app-reindexdb.html
It will still create multiple connections, but you won't need to run multiple
commands.
чт, 16 черв. 2022 р. о 22:34 Ja
I believe you should be able to use reindexdb with parallel jobs:
https://www.postgresql.org/docs/13/app-reindexdb.html
It will still create multiple connections, but you won't need to run
multiple commands.
чт, 16 черв. 2022 р. о 22:34 James Pang (chaolpan)
пише:
> Hi ,
>
> We plan to migrate
Hi ,
We plan to migrate large database from Oracle to Postgres(version 13.6, OS
Redhat8 Enterprise), we are checking options to make data load in Postgres
fast. Data volume is about several TB, thousands of indexes, many large table
with partitions. We want to make data load running fast a
