search

dataegret / pgcompacttable

BSD 3-Clause "New" or "Revised" License
314 stars 48 forks source link

--exclude-table not working #32

Closed Claud closed 4 years ago

Claud commented 4 years ago 
./pgcompacttable -h localhost -U postgres -d .... --exclude-table products -v -s

.....
[Thu Oct  1 13:19:02 2020] (....:public.products) Start handling table public.products
[Thu Oct  1 13:19:40 2020] (....:public.products) Vacuum initial: 4229952 pages left, duration 37.336 seconds.
[Thu Oct  1 13:23:38 2020] (....:public.products) Bloat statistics with pgstattuple: duration 237.898 seconds.
[Thu Oct  1 13:23:38 2020] (....:public.products) Statistics: 4229952 pages (5263584 pages including toasts and indexes), it is expected that ~87.200% (3688486 pages) can be compacted with the estimated space saving being 28.141GB.
[Thu Oct  1 13:23:38 2020] (....:public.products) Update by column: free_delivery.
......
Melkij commented 4 years ago

Hello Hmm, looks like exclude-table should be fully qualified name, eg --exclude-table public.products

Claud commented 4 years ago

it worked thanks.