search

reorg / pg_repack

Reorganize tables in PostgreSQL databases with minimal locks
BSD 3-Clause "New" or "Revised" License
1.85k stars 170 forks source link

Table exclude option #18

Open rmwpl opened 10 years ago

rmwpl commented 10 years ago

It would be useful to have an option to exclude tables from repacking based on name/schema with regex.

misullivan commented 9 years ago

+1 to that I have a table that is effectively "write once" and is most of the DB size ... repack cannot write a new table for it as:

1/ it would take more than 20 hours. 2/ It uses all available disk (and more if there was more.)

bimcas commented 2 years ago

Hi, I agree that it would be great to have an exclude option fro databases, schemas, and tables from repacking . Now I found just: -C, --exclude-extension don't repack tables which belong to specific extension

Do you plan to implement such option in the upcoming releases?