maintenance + cloudsqladmin

32 views
Skip to first unread message

Pedro Agustin Lucca

unread,
Feb 17, 2022, 5:30:38 AM2/17/22
to Google Cloud SQL discuss
Hi,

Does anyone know if the cloudsqladmin user performs some type of task after a scheduled maintenance, cloudsql postgres instance.
Once the maintenance is finished, the cloudsqladmin transactions per second increased considerably. I couldn't find anything in the documentation.

Any hints are much appreciated! 

barrado

unread,
Feb 22, 2022, 5:04:13 AM2/22/22
to Google Cloud SQL discuss
Not sure of the kind of transactions you are seeing and how are you displyaing them but according to the documentation the last step of a maintenance includes:

"The updated database engine is started on the data disk. Using a common data disk ensures that all transactions written to the original instance prior to maintenance are still present on the updated database after maintenance. If any incomplete transactions didn't finish rolling back during database shutdown, the database automatically goes through crash recovery to ensure that the database is restored to a usable state." 

Which might explain those transactions that you see. 
Reply all
Reply to author
Forward
0 new messages