Greetings,
* Jasen Lentz (jlentz@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 database servers e.g. inserts, updates, etc during the extended backups?
> Not according to sar reports
And there's no increased activity on the backup server either?
Have you looked at network traffic for the duration? And/or disk i/o on
each system? If you ran a backup once and then immediately after and
that's the 'fast' case then you may be seeing performance be better due
to a lot of data being in the filesystem cache. pg_basebackup being
single-threaded probably doesn't help here either, you might want to
consider one of the parallel-backup options.
Thanks,
Stephen
