| From: | Lucas <root(at)sud0(dot)nz> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | PostgreSQL 9.2 high replication lag |
| Date: | 2021-07-14 01:09:51 |
| Message-ID: | Z14WgPUs_T-sranXV8i1KakN-eGRgP7fFcKUR8wHJDmjR-V8tHXkIIVWPxEEUd69GBeQCCKD0BeFn4f9AKItYa22mk_DzQP0yKuhRoyXZCc=@sud0.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all,
I have a cluster of PostgreSQL 9.2 servers (yes, I know... we're working on a migration to PG 13) that has one master and one slave.
[image.png]
I know that the streaming replication is expected to have delays, but this is getting worse and worse everyday. You can see the replication gap is reaching >10 minutes quite often.
The servers are hosted in AWS as EC2 instances and they're both in different AZs. I also know that the streaming replication was first introduced in PG 9.0, so we're using a very old version of it.. I'm sure it has improved over the years...
What can I look for to make this lag not so high? Is there anything I could change in my postgresql.conf files? Any tips?
Thanks!
---
Regards,
Lucas
> This message is encrypted. Both the Public Key and the GPG encrypted message are included in this email so that you can verify its origin.
| Attachment | Content-Type | Size |
|---|---|---|
| publickey - root@sud0.nz - 0xC5E964A1.asc | application/pgp-keys | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lucas | 2021-07-14 03:01:10 | Re: PostgreSQL 9.2 high replication lag |
| Previous Message | Glauco Torres | 2021-07-14 00:35:25 | PostgreSQL 12 on AWS Graviton2 ARM problem with IOPS |