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

New answers tagged

1 vote
Accepted

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?

https://stackoverflow.com/questions/65069778/postgresql-rename-table-cascade-renaming-to-objects-like-indices-constraints/78485773#78485773 This will rename any index which name not following $...
n0099's user avatar
  • 119

Top 50 recent answers are included