nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

reindex using "reindex" command in postgresql

yockee

How to reindex feature class that just been loaded into postgresql ? I load the data using Append tool.

I know I can use "rebuild Indexes (Data Management)".

But, can I use Postgresql command such as

"REINDEX (verbose, concurrently)
TABLE dbgis.bnp__attach;"

Note: this table is an attachment that contains blob data. It has 200K+ records and each row has around 1MB of blob (picture)

Vind meer berichten getagd met

Accepted answers

VinceAngelo

Yes, you can manage indexes manually with SQL in pgAdmin, psql, or even arcpy.ArcSDESQLExecute().

- V

All comments

VinceAngelo

I never have. I do run CLUSTER, VACUUM, and REINDEX at quiet times, but "quiet" can be hard to find in 24x7 systems. REINDEX will slow down queries, but not cause them to fail. VACUUM might grab a lock; the docs will say for sure.

- V

yockee

Hi @VinceAngelo do I have to turn off the corresponding map service, stop editing using DML queries and quit any arcgis pro apps that access the feature class during the index rebuild ?

Thanks

VinceAngelo

Yes, you can manage indexes manually with SQL in pgAdmin, psql, or even arcpy.ArcSDESQLExecute().

- V

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.