Tuesday, March 6, 2018

[google-cloud-sql-discuss] Re: (Postgres) "WARNING: terminating connection because of crash of another server process"

Hello Carlos, 

The standard form of VACUUM removes dead row versions in tables and indexes and marks the space available for future reuse. However, it will not return the space to the operating system, except in the special case where one or more pages at the end of a table become entirely free and an exclusive table lock can be easily obtained. In contrast, VACUUM FULL actively compacts tables by writing a complete new version of the table file with no dead space. This minimizes the size of the table, but can take a long time. It also requires extra disk space for the new copy of the table, until the operation completes. You may gather more detail on this feature by reading the "Routine Vacuuming" documentation page

General troubleshooting advice is available on the "Diagnosing Issues with Cloud SQL Instances" page

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/e9a9a6cc-e326-4601-ac36-2601fe6ec768%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment