Search Postgresql Archives

Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
From: hubert depesz lubaczewski <depesz@xxxxxxxxxx>
Date: Wed, 20 Aug 2025 13:35:20 +0200
Cc: Adrian Klaver <adrian.klaver@xxxxxxxxxxx>, PostgreSQL General <pgsql-general@xxxxxxxxxxxxxxxxxxxx>
In-reply-to: <SJ0PR15MB5245919B78ECB02696ADD1959A30A@SJ0PR15MB5245.namprd15.prod.outlook.com>
References: <aKSyq74zIuLS-2B5@depesz.com> <d1d40328-ae3a-4089-9ee0-beade92d7c45@aklaver.com> <a2cd8084-b93e-4da0-8999-569a6e58ef6b.8f62f83c-ab51-428e-98d1-ab1abb243a49.93a25b3a-0b25-4d18-8a69-08f841e737cb@emailsignatures365.codetwo.com> <a2cd8084-b93e-4da0-8999-569a6e58ef6b.b1460fbe-55a2-4060-995f-39f4e2f3c7f9.5415824a-634b-472f-8c56-ab10d48e91f7@emailsignatures365.codetwo.com> <SJ0PR15MB5245919B78ECB02696ADD1959A30A@SJ0PR15MB5245.namprd15.prod.outlook.com>
Reply-to: depesz@xxxxxxxxxx

On Tue, Aug 19, 2025 at 08:25:26PM +0000, Scot Kreienkamp wrote:
> Synchronous commit?  Or asynchronous?

Isn't this potential problem on primary, and not replica? Anyway,
synchronous commit is set to "on", and "synchronous_standby_names" is
empty.

Best regards,

depesz

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
  - From: hubert depesz lubaczewski
- Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
  - From: Adrian Klaver
- RE: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
  - From: Scot Kreienkamp

Prev by Date: pg_upgrade from 18beta1 -> 18beta3 - problem with btree_gist contrib module / extension
Next by Date: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Previous by thread: RE: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Next by thread: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Postgresql & PHP] [Yosemite]