|
|
|
pgcompact не освобождаем занимаемое место
|
|||
|---|---|---|---|
|
#18+
PostgreSQL 9.2.4 on i686-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 32-bit Лог запуска : 2015-01-23 07:34:17 - Checking current status... Filesystem 1M-blocks Used Available Use% Mounted on /dev/sda10 94817 25940 64061 29% /srv dbsize_mb ----------- 25604.00 ... DELETE 4850938 ... 2015-01-23 07:36:22 - Doing ./pgcompact --dry-run ... Fri Jan 23 07:36:24 2015 "PPCDB" NOTICE Statictics calculation method: approximation. Fri Jan 23 07:36:24 2015 "PPCDB", public.data NOTICE Statistics: 762577 pages (3272187 pages including toasts and indexes), approximately 3.88% (29555 pages) can be compacted reducing the size by 231 MB. 2015-01-23 07:36:24 - Doing ./pgcompact --reindex ... Fri Jan 23 07:36:26 2015 "PPCDB" NOTICE Statictics calculation method: approximation. Fri Jan 23 07:57:44 2015 "PPCDB", public.data NOTICE Statistics: 762577 pages (3272225 pages including toasts and indexes), approximately 8.97% (68378 pages) can be compacted reducing the size by 534 MB. Fri Jan 23 07:57:44 2015 "PPCDB" NOTICE Processing complete. Fri Jan 23 07:57:44 2015 "PPCDB" NOTICE Processing results: size reduced by 0 bytes (-304 kB including toasts and indexes) in total. Fri Jan 23 07:57:44 2015 NOTICE Processing complete: 0 retries from 10. Fri Jan 23 07:57:44 2015 NOTICE Processing results: size reduced by 0 bytes (-304 kB including toasts and indexes) in total, 0 bytes (-304 kB) "PPCDB". 2015-01-23 07:57:45 - SUCCESS 2015-01-23 07:57:45 - Checking current status... Filesystem 1M-blocks Used Available Use% Mounted on /dev/sda10 94817 25956 64045 29% /srv dbsize_mb ----------- 25604.00 (1 row) # select * from pg_stat_all_tables where relname = 'data'; -[ RECORD 1 ]-----+------------------------------ relid | 16440 schemaname | public relname | data seq_scan | 13 seq_tup_read | 861242985 idx_scan | 572841 idx_tup_fetch | 301110403023 n_tup_ins | 33138963 n_tup_upd | 91332594 n_tup_del | 96182987 n_tup_hot_upd | 28355 n_live_tup | 102731875 n_dead_tup | 0 last_vacuum | 2015-01-23 07:57:44.716149+00 last_autovacuum | last_analyze | 2015-01-22 21:12:06.825141+00 last_autoanalyze | 2015-01-22 05:39:34.81197+00 vacuum_count | 9 autovacuum_count | 0 analyze_count | 8 autoanalyze_count | 15 Почему так происходит ? Строки удалились, много строк. Однако база не сжалась. До этого все нормально, ожидаемо работало ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.01.2015, 11:54 |
|
||
|
pgcompact не освобождаем занимаемое место
|
|||
|---|---|---|---|
|
#18+
rinace, pgcompact при запуске без --force не обрабатывает таблицу и/или индекс если там нет хотя бы 20% свободного места так как обычно это бессмысленная трата ресурсов базы. --Maxim Boguk www.postgresql-consulting.ru ... |
|||
|
:
Нравится:
Не нравится:
|
|||
| 26.01.2015, 13:26 |
|
||
|
|

start [/forum/topic.php?fid=53&fpage=116&tid=1998222]: |
0ms |
get settings: |
5ms |
get forum list: |
11ms |
check forum access: |
2ms |
check topic access: |
2ms |
track hit: |
58ms |
get topic data: |
7ms |
get forum data: |
2ms |
get page messages: |
28ms |
get tp. blocked users: |
1ms |
| others: | 199ms |
| total: | 315ms |

| 0 / 0 |
