| From: | Torsten Förtsch <tfoertsch123(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | AWS vs GCP storage |
| Date: | 2022-02-22 20:27:39 |
| Message-ID: | CAKkG4_nT988c=y_CrHiH1ioWD_oFFGO0Xq0rRg1uMgbiF2oJtQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I have a few databases with several TB-sized tables. We recently moved one
of those databases from AWS EC2 to GCP. Today I ran VACUUM FREEZE on those
tables and every time I saw our application freezing up (and throwing tons
of errors) for a few minutes right after the message about the end of
vacuum (duration: 30182257.392 ms statement: vacuum freeze verbose ...).
We never saw anything like that on AWS.
The database is 9.6. At the moment I have no details about the storage
configuration on GCP. The machine was set up by another department.
Any suggestions on why that is happening and how to prevent it would be
appreciated.
Thanks,
Torsten
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2022-02-22 20:50:04 | Re: AWS vs GCP storage |
| Previous Message | Tom Lane | 2022-02-22 15:56:23 | Re: Full text search - wildcard and a stop word |