RE: pg_basebackup inconsistent performance

2020-05-07 Thread Jasen Lentz
org Subject: Re: pg_basebackup inconsistent performance Greetings, * Jasen Lentz (jle...@sescollc.com) wrote: > Where are the machines you are backing up from/to relative to each on the > network? > Direct ethernet connection between 10G network interfaces Is the backup server sh

Re: pg_basebackup inconsistent performance

2020-05-06 Thread Stephen Frost
Greetings, * Jasen Lentz (jle...@sescollc.com) wrote: > Where are the machines you are backing up from/to relative to each on the > network? > Direct ethernet connection between 10G network interfaces Is the backup server shared among other systems..? > Is there increased activity on the databa

RE: pg_basebackup inconsistent performance

2020-05-06 Thread Jasen Lentz
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

Re: pg_basebackup inconsistent performance

2020-05-06 Thread Adrian Klaver
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 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

Re: pg_basebackup inconsistent performance

2020-05-06 Thread Adrian Klaver
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 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

pg_basebackup inconsistent performance

2020-05-06 Thread Jasen Lentz
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