We have pg_basebackup running on two of our DB servers that are replicated. We
are running postgres 11, and it seems we are getting inconsistent performance
from the backups and unsure as of why. We start out at 5-6 hours over a
dedicated 10G port for 7TB. It creeps up to 8-9 hours then all o
Sent: Wednesday, May 6, 2020 10:28 AM
To: Jasen Lentz ; pgsql-general@lists.postgresql.org
Subject: Re: pg_basebackup inconsistent performance
On 5/6/20 5:44 AM, Jasen Lentz wrote:
> We have pg_basebackup running on two of our DB servers that are
> replicated. We are running postgres 11, and it s
em stats, nothing changed, just the backups running
extremely long.
Was looking into pgbackrest, just haven't gotten it configured yet
-Original Message-
From: Stephen Frost
Sent: Wednesday, May 6, 2020 12:30 PM
To: Jasen Lentz
Cc: Adrian Klaver ;
pgsql-general@lists.postgresql.
In Postgres 11.6-2, what is the default timeout for wal_sender_timeout if it is
commented out?
[cid:image003.png@01D62466.8C9AAEE0]
Jasen M. Lentz, M.Ed
Lead Systems Administrator
Sesco Enterprises, LLC
4977 State Route 30 East (Mailing Address Only)
Greensburg, PA 15601
W: (724) 837-1991 x207
Would upgrading from 11.6-2 to 11.7-current give us any performance advantages?
We are seeing intermittent performance problems that come and go. Also are
there any fixes for the wal_sender and pg_basebackup between the versions?
