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
constraints.
The questions is instead of drop index and create index, we check update
pg_index set indisready=false and reindex again after 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
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
