Enterprise geodatabases use log file tables to maintain lists of selected records. Records are written to log file tables for later use by the application in the following situations:
- You (or a tool or other process you run) create a selection set of a specific size—more than 100 records in ArcMap; more than 1,000 records in ArcGIS Pro; more than 1,000 records when Object IDs are requested from a feature service.
- You reconcile or post to a versioned geodatabase.
- A client application checks out data for disconnected editing.
ArcGIS creates log files as temporary tables in the PostgreSQL database whenever log file tables are needed. Tables are created per user.
Tables created for temporary log file tables
Two temporary log file tables are created in the database. The tables are named pg_temp_<#>.sde_logfiles and pg_temp<#>.sde_logfile_data.
Permissions to use temporary log file tables
The following permissions are required to use shared log file tables in PostgreSQL:
- CONNECT
- TEMP
These privileges can be granted directly to individual login roles or groups or inherited from the public role or privileges granted on the database.