| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug |
| Date: | 2025-08-20 16:08:11 |
| Message-ID: | aKXy64uaOasow3eK@depesz.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 20, 2025 at 08:14:47AM -0700, Adrian Klaver wrote:
> Hmm.
>
> From initial post:
>
> "For ~ 1 second there are no logs going to log (we usually have at 5-20
> messages logged per second), no connection, nothing. And then we get
> bunch (30+) messages with the same milisecond time."
>
> Are the 30+ messages all coming in on one connection or multiple
> connections?
Multiple connections.
> Also to be clear these are statements that are being run on the replica
> locally, correct?
What do you mean locally?
Application servers are *not* on the same server as the db. So no, they
are not local.
> Does the AWS monitoring indicate any issues?
Nope. All looks "fine".
Same for our monitoring - CPU usage, iops, load.
Best regards,
depesz
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Sabino Mullane | 2025-08-20 16:12:25 | Re: Domains vs data types |
| Previous Message | Ron Johnson | 2025-08-20 15:43:57 | Re: Domains vs data types |