Do you have an idea or suggestion based on your experience with Azure Database for PostgreSQL?

← Azure Database for PostgreSQL

pg_squeeze is an extension that removes unused space from a table and optionally sorts tuples according to particular index

https://github.com/cybertec-postgresql/pgsqueeze
pgsqueeze is an extension that removes unused space from a table and
optionally sorts tuples according to particular index (as if CLUSTER [2]
command was executed concurrently with regular reads / writes). In fact we try
to replace pg_repack [1] extension.

25 votes
Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Kai xu shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

3 comments

Sign in
(thinking…)
Sign in with: Microsoft
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Kai commented  ·   ·  Flag as inappropriate

    Plus 1 for any solution to remove bloat without full vacuum
    pg_repack for example

  • Michael Korbakov commented  ·   ·  Flag as inappropriate

    Actually, ANY solution to clean up bloat will be very welcome. As for now the only way to do that is to run VACUUM FULL which is not acceptable for production databases.

Azure Database for PostgreSQL: Extension

Categories

Feedback and Knowledge Base

(thinking…)
Hosted by UserVoice