rinace
Дата: 26.01.2015 11:54:45
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
Почему так происходит ?
Строки удалились, много строк.
Однако база не сжалась.
До этого все нормально, ожидаемо работало