Question : Can I stop it ?

[sebastienbianco]

Hello,

I want to run this tool on a very big table (~600G to retreive). We test it on a preproduction DB when activity occurs on the table and the process took 52h and generated an overcost of 25% of DB load-average.

I'm quite confident to run it in production, but I have a last question : can I stop safely the process if something goes wrong on production (too high latency for users, multiplication of locks, anything else...) ? If the process is killed, can we loose some datas ?

I will (obviously) backup my DB before running this tool, but I prefer to have all informations before going to war :).

Regards,

[MaximBoguk]

Hi, You can safely stop pgcompacttable in any moment yes (via usual ctrl-c) However, if you stop pgcompacttable during rebuild indexes stage, then there are risk of dangling temporary indexes will be left on the table, which should be cleaned manually (via drop index CONCURRENTLY).

…

On Wed, Feb 13, 2019 at 7:28 PM sebastienbianco ***@***.***> wrote: Hello, I want to run this tool on a very big table (~600G to retreive). We test it on a preproduction DB when activity occurs on the table and the process took 52h and generated an overcost of 25% of DB load-average. I'm quite confident to run it in production, but I have a last question : can I stop safely the process if something goes wrong on production (too high latency for users, multiplication of locks, anything else...) ? If the process is killed, can we loose some datas ? I will (obviously) backup my DB before running this tool, but I prefer to have all informations before going to war :). Regards, — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#22>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAnGAKgLG_FvY2RUZldWODx6u4JcLBGQks5vM8yRgaJpZM4a43Bi> .

-- Maxim Boguk Senior Postgresql DBA https://dataegret.com/ Phone RU: +7 985 433 0000 Phone UA: +380 99 143 0000 Phone AU: +61 45 218 5678 LinkedIn: http://www.linkedin.com/pub/maksym-boguk/80/b99/b1b Skype: maxim.boguk "Доктор, вы мне советовали так не делать, но почему мне по-прежнему больно когда я так делаю ещё раз?"

[sebastienbianco]

Hi,

Ok. Thanks for the answer !