Lightsail Postgresql database storage keep decreasing when idle

0

i have provisioned AWS database lightsail with postgresql 16.3, but i when the instance is created, when monitoring free-storage metrics, the storage keep decreasing, but i am not having any database connection, the instance is freshly created and no operation has been done. Can anybody help why is this happening? Screenshot Metrics

asked a month ago218 views
1 Answer
1
Accepted Answer

Looks to me there are some maintenance tasks running. These tasks include auto-vacuum processes, log rotations, and other routine system maintenance activities that run automatically to optimize database performance and ensure data integrity. Even without any user-initiated connections or operations, these background processes can generate logs and temporary files, gradually consuming storage space.

profile picture
EXPERT
answered a month ago
profile pictureAWS
EXPERT
iBehr
reviewed a month ago
  • yes, it seems the storag is now stablize. thank you for the answer