postgresqlvacuum
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| postgresqlvacuum [2022/02/13 23:02] – [Vacuum Progress] z0hpvk | postgresqlvacuum [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 53: | Line 53: | ||
| This will create a new unfragmented table and rebuild all associated indexes.\\ | This will create a new unfragmented table and rebuild all associated indexes.\\ | ||
| However this will cause a full lock on the table, even SELECT queries will have to wait for the process to complete.\\ | However this will cause a full lock on the table, even SELECT queries will have to wait for the process to complete.\\ | ||
| + | Instead you can use the extension [[https:// | ||
| The basis of the below SQL query was taken from: [[https:// | The basis of the below SQL query was taken from: [[https:// | ||
postgresqlvacuum.1644793376.txt.gz · Last modified: 2025/03/08 22:23 (external edit)