Skip to content
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.

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

Add repack mode #15

Open
jberkus opened this issue Oct 21, 2014 · 0 comments
Open

Add repack mode #15

jberkus opened this issue Oct 21, 2014 · 0 comments

Comments

@jberkus
Copy link
Contributor

jberkus commented Oct 21, 2014

Depends On: #4, #6, probably others.

Add mode to flexible_freeze to opportunistically pg_repack severely bloated tables. This would be very useful, but suffers from a number of challenges:

  • currently pg_repack is not designed to be called from another program. It's output depends on being read by a human on stderr. pg_repack would need an API, which might not be feasible.
  • there's no safe way to cancel a pg_repack if the time limit runs out. So we'd need to estimate the time required for a repack before starting.
  • since pg_repack will cancel competing transactions, do we really want to run it unattended?
  • also, pg_repack can use up disk space, so we'd need a way to check available disk space and refuse to proceed if it's not at least (table_size * 2). However, a platform-agnostic way to check available disk space would be complicated.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant