postgresqlvacuum
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| postgresqlvacuum [2024/03/01 15:37] – 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 [[postgresqlextensions|pg_repack]]. \\ | + | 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.1709307470.txt.gz · Last modified: 2025/03/08 22:23 (external edit)