RE: pg_basebackup inconsistent performance

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

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