How to automate removal of bloat ? Why EDB dont have any Tool to remove bloat ?

Highlighted
Level 2 Adventurer

How to automate removal of bloat ? Why EDB dont have any Tool to remove bloat ?

Dear Experts,

 

One of big challenge for any DBA is to remove the bloat without any downtime, In Open Community PostgreSQL we have some tools like pg_repack, pg_squeeze, pgcompact etc to remove bloat on table or indeces without any downtime and impact on the on going transactions.

 

But why we dont have this kind of feature in EDB PPAS, why EDB dont have its own such tools to help their clients to resolve the bloat issue in mission critical environment where downtime is next to impossible.

 

Is there any workaround in EDB PPAS 9.4 to remove the bloat on table and indices without any downtime.

 

Regards,

Moin

Archived Discussions


Effective March 31st, we will no longer engage on PostgresRocks.


How to engage with us further?


  • Thought Leadership: EDB Blogs

  • Tips and Tricks: Postgres Tutorials

  • Customer Support: Create a Case Please note: Only customers with an active EDB support subscription and support portal authorization can create support ticket

  • Engage on Stackoverflow While engaging on Stackoverflow tag the question with EDB or EnterpriseDB.

3 REPLIES 3
Highlighted
Gold Adventurer

Re: How to automate removal of bloat ? Why EDB dont have any Tool to remove bloat ?

hi @Moin, yu can use this tools in EDB, remember that edb is based on postgresql.

 

just Install the tool, this tools are extension

 

regards 

Highlighted
Level 2 Adventurer

Re: How to automate removal of bloat ? Why EDB dont have any Tool to remove bloat ?

Hi Asotolongo,

 

It too agree with you on this that we can use this tools in EDB. But my Question is to EDB Support why they are not supporting this tools ?

 

If they really support any of those tools, then i will be first one to use.

 

Regards,

Moin

Highlighted
EDB Team Member

Re: How to automate removal of bloat ? Why EDB dont have any Tool to remove bloat ?

Hi Moin,

 

We have been consistently working with the community to make vacuum operations which are performed automatically by autovacuum to work efficiently and ensure that bloat doesn't occur. The tools might work great however having the issues fixed in the core is our priority.

 

Mr. Robert Hass who is also our Chief Database Architect has elaborated on the direction in which-we are moving while also touching on the tools available in the following blog :

http://rhaas.blogspot.com/2018/01/do-or-undo-there-is-no-vacuum.html

 

Hope this helps.

© 2019 EnterpriseDB Corporation. All rights reserved.   |   Privacy Policy   |  Terms of Use   |   Trademarks