pg_repack | Reorganize tables in PostgreSQL databases with minimal locks | Database library

by reorg C Version: ver_1.4.8 License: BSD-3-Clause

X-Ray Key Features Code Snippets Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | pg_repack Summary

pg_repack is a C library typically used in Database, PostgresSQL applications. pg_repack has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. You can download it from GitHub.

Reorganize tables in PostgreSQL databases with minimal locks

Support

Quality

Security

License

Reuse

Support

pg_repack has a medium active ecosystem.

It has 1556 star(s) with 156 fork(s). There are 58 watchers for this library.

It had no major release in the last 6 months.

There are 64 open issues and 167 have been closed. On average issues are closed in 447 days. There are 16 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of pg_repack is ver_1.4.8

Quality

pg_repack has 0 bugs and 0 code smells.

Security

pg_repack has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

pg_repack code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

pg_repack is licensed under the BSD-3-Clause License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

pg_repack releases are not available. You will need to build from source code and install.

It has 56 lines of code, 0 functions and 1 files.

It has low code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of pg_repack

Get all kandi verified functions for this library.

pg_repack Key Features

No Key Features are available at this moment for pg_repack.

pg_repack Examples and Code Snippets

No Code Snippets are available at this moment for pg_repack.

Community Discussions

Trending Discussions on pg_repack

What is difference between pg_squeeze and pg_repack?

QUESTION

What is difference between pg_squeeze and pg_repack?

Asked 2022-Feb-21 at 14:36

I've been working on optimizing tables in database. One of our table requires monthly vacuuming because of cleaning up processes.pg_squeeze Table size can get upto 25 GB. As this table is used by production users, we can't afford downtime every month to run VACUUM FULL.

I found that pg_squeeze and pg_repack can be used for this purpose. But I'm not able to understand the difference between those two. Can someone please explain what is the difference and which will be more suitable for me to use?

Thank you.

...

ANSWER

Answered 2022-Feb-11 at 09:22

The main difference is that pg_queeze operates entirely inside the database, with no need for an external binary. It also has a background worker that will schedule table rewrites automatically if certain criteria are met.

So you could say that pg_repack is less invasive (for example, installation requires no restart of the database), but pg_squeeze is more feature complete.

Disclaimer: I work for the company who wrote pg_squeeze.

Source https://stackoverflow.com/questions/71077403

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install pg_repack

You can download it from GitHub.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: