Planet PostgreSQL Planet PostgreSQL -

Manisankar Kanagasabapathy: Rebuilding Tables online using pg_repack in PostgreSQL

Any database engine, including PostgreSQL, requires some routine maintenance to ensure optimal performance. Especially when there are massive delete or purge operations to delete rows from a Table, the fragmentation builds up within a table. Reclaim this fragmented space from disk requires a table to be rebuilt. At HexaCluster, we had many Customers asking us […] The post Rebuilding Tables online using pg_repack in PostgreSQL appeared first on HexaCluster.

本文介绍了在PostgreSQL中重建表的方法,包括使用VACUUM FULL命令的限制,Oracle中使用DBMS_REDEFINITION包的手动步骤,以及PostgreSQL中的pg_repack扩展。pg_repack可以在不中断读写操作的情况下重建表,并有效去除碎片。使用pg_repack重建表简单且提高数据库性能和存储利用率。

Oracle PostgreSQL VACUUM FULL pg pg_repack 重建表

相关推荐 去reddit讨论