I have a PostgreSQL database in Cloud SQL, and I want to export some data from it using the UI.
Just after hitting the Export button you are shown the following warning:
What does "perform operations" mean?
Will my application still be able to query (read and write) the database while the export is ongoing?
What does "perform operations" mean?
Perform operations in this context would mean changing instance configurations, so long your instance has excess capacity to process your export your app can continue to use the DB.
Will my application still be able to query (read and write) the database while the export is ongoing?
Yes, although there might be a performance impact on the app, depending on size of the DB instance and the size of the export.
Have a look at the best practices guide (if you haven't already), while exporting from PostgresDB.
If you are worried about the performance impact on the app / end-users, you could create a read replica of your existing DB and export the data from the replica.
Usually yes, your database will still be able to serve SQL queries, although due to the export, it might get slower and some DDL statements such as creating, modifying and removing database objects will consequently be blocked. The warning mainly refers to Cloud SQL API operations.
