8000 pg_compacttable takes way too much time compacting a table · Issue #55 · dataegret/pgcompacttable · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
8000

pg_compacttable takes way too much time compacting a table #55

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
ramili4 opened this issue Feb 25, 2025 · 1 comment
Open

pg_compacttable takes way too much time compacting a table #55

ramili4 opened this issue Feb 25, 2025 · 1 comment

Comments

@ramili4
Copy link
ramili4 commented Feb 25, 2025

Hi there! First off, a big shoutout to the developers of pg_compacttable! It's a really useful tool. I've noticed it can be a bit slow on larger tables. I was wondering if there are any parameters or configuration options that can be tweaked to speed it up somehow? Are there any best practices for optimizing its performance when dealing with substantial datasets so it takes less time to compact tables?
@Melkij
Copy link
Collaborator
Melkij commented Feb 25, 2025

--delay-ratio=0 mostly (disable sleep between iterations)
--initial-reindex can be useful: the indexes will be rebuilt first, so subsequent updates will create less IO when updating the indexes.

But in general pgcompacttable is quite slow (which is not bad as it does not create a huge system load). You might also find pg_repack useful.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@Melkij @ramili4
0