Help Center/ Relational Database Service_RDS for PostgreSQL/ FAQs/ Database Usage/ Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?
Updated on 2026-10-08 GMT+08:00

Does the OPTIMIZE TABLE Operation Lock Tables on an RDS DB Instance?

When the OPTIMIZE TABLE operation is performed on an RDS DB instance, the tables are locked only for a short period of time. During the table locking period, DML operations can be performed but other DDL operations cannot be executed concurrently. Additionally, this operation rebuilds the table, taking a relatively long time and consuming significant CPU and disk resources. If there is a high volume of concurrent DML operations, the final table locking duration will be extended. To minimize the impact on workloads, perform the OPTIMIZE TABLE operation during off-peak hours.