Skip to main content
Share Your Experience: Take the 2024 Developer Survey

New answers tagged

1 vote

PostgreSQL: What are different operations make the use of Temp files?

VACUUM and ANALYZE shouldn't create temporary files. First of all, the statistics from pg_stat_database need not be 100% accurate. Second, pg_stat_database.temp_bytes measures the size of temporary ...
Laurenz Albe's user avatar
  • 52.9k
0 votes

Is automatically renaming indexes when renaming columns relevant for database health/maintenance? This will rename any index which name not following $...
n0099's user avatar
  • 119

Top 50 recent answers are included